Hi,
I have recently started trying to teach myself VBA. I don't have much experience using the language yet so I would love it if anyone could take a look at my code and tell me what I am doing wrong.
I am trying to write a sub to analyze the theoretical sales data I created. For each region, if the sales increase for three consecutive quarters (Q4 > Q3 > Q2 > Q1), I want to fill the cell with the Region # in it green. Also, if the sales decrease for three consecutive quarters, I want to fill the cell with the Region # in it red.
I have started writing the code but keep getting different error messages and am really stuck at this point. Any help would be greatly appreciated. Thanks in advance!
Bookmarks