VBA Macro Copy and Paste Loop Help
Closed
nicole4763
Posts
3
Registration date
Tuesday May 31, 2016
Status
Member
Last seen
June 1, 2016
-
May 31, 2016 at 06:30 PM
Blocked Profile - Jun 2, 2016 at 04:22 PM
Blocked Profile - Jun 2, 2016 at 04:22 PM
Related:
- VBA Macro Copy and Paste Loop Help
- Vba case like - Guide
- Number to words in excel without vba - Guide
- Fruit loop studio - Download - Musical production
- Game loop - Download - Android emulators
- Enable vba in excel - Guide
Jun 1, 2016 at 10:27 PM
Sorry I think I made this question confusing! I am not actually using colors, I am just using colors as a value. I actually resposted this question using names to hopefully make it a little bit easier to understand. I would eventually be using formulas in those cells, but I just want to be able to copy and paste those cells exactly as they are (format and formulas) down many times without having to manually do it. Hopefully that clarifies it a little - I appreciate your quick response!
Thanks,
Nicole
Jun 2, 2016 at 04:22 PM
Try the IF function. Syntax is as follows:
=IF(logic_test,true,false)
With that in mind:
=IF(A1="green","it is green", "it is not green")
Would this help?