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 and naming that range a new name.
Bookmarks