[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