I'm trying to create a case with IF statements that then format the next cell with values stored in a variable. If I add msgbox ClrGreen it returns the values but I can't see how it apply it to the IF statement. I've tried this with functions and subs and am not getting anywhere. My Case and If's work perfectly but the code is getting quite large and I want to reduce it with variables. Any help would be appreciated.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzerPlease Login or Register to view this content.
Bookmarks