Formula using stored variable

**fireflydreams** · 04-16-2015, 10:07 AM

Hi

I'm trying to code a macro to enter a formula into multiple cells. The thing is, part of the range of the formula has been stored in a variable as the column its going to reference is going to change:

Range("C5").Formula = "=COUNTIFS(Table!$I:$I, $E$2,Table!SkillLetter01:SkillLetter01, Reports!B5)"

I need to replace SkillLetter01 with the value stored in SkillLetter but cannot for the life of me work out how. Any help would be appreciated!

**judgeh59** · 04-16-2015, 10:28 AM

something like

Please Login or Register  to view this content.

I think I have all the right double quotes and &'s

**fireflydreams** · 04-16-2015, 10:34 AM

Perfect! Thanks. Knew there would be a simple solution :D

**judgeh59** · 04-16-2015, 10:36 AM

sometimes it's hard to get your head wrapped around all the double quotes and &'s....glad I could help...

Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...