[SOLVED] How do I create a range in VBA for multiple columns using a named range cell?
Basically, I have one named cell as a reference, and I'd like to use VBA to change the cell colour for the named cell and the 4 columns to the right of it.
Is there a way to create a new range in VBA using the named range as a starting point + 4 columns? Without selecting the range on the sheet...
https://www.excelforum.com/sho....wthread.php?t=142169
Discover the world at Altruu, The Discovery Engine