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.
Figured it out myself
@c.davidson
And for people that are looking for a solution having the same problem, the answer is............
Experience trumps academics every day of the week and twice on Sunday.
Please Login or Register to view this content.
Thank you very much.
Someone in the future will be happy with this.
The way I did it was:
This is just an example to change the value of that range to 1, I wanted to change the interior colour.Please Login or Register to view this content.
Or just this:
Please Login or Register to view this content.Please Login or Register to view this content.PHP Code:TMS $B$6 $B$6:$F$6
Sample $B$2 $B$2:$F$2
Named_Cell $B$4 $B$4:$G$4
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
To change the Interior colour:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks