I have a sheet that I have ctrl - clicked (in Excel) to select 5 to 6 cells and I want to use .colorindex=3. how do I do it without having to create a named range (in VBA)?
I have a sheet that I have ctrl - clicked (in Excel) to select 5 to 6 cells and I want to use .colorindex=3. how do I do it without having to create a named range (in VBA)?
Hi cooldraft
in vba just use..
Selection.Interior.ColorIndex = 3
zeddy
Thank you, you're awesome.
OK now how do I reference the unselected cells?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks