I need to create code that evalates a cell's color in a column range "u4:u240" and if doesnt match a certain color(grey) then change cell color back to white. i dont want to use coditional formatting either.
thanks,
cb
I need to create code that evalates a cell's color in a column range "u4:u240" and if doesnt match a certain color(grey) then change cell color back to white. i dont want to use coditional formatting either.
thanks,
cb
Lookup "ColorIndex" in HelpPlease Login or Register to view this content.
Ben Van Johnson
I am getting an error of "for without next"
Sent from my iPad using Tapatalk
I got it, it was missing "next c". Thanks!
Sent from my iPad using Tapatalk
Can you have it ignore black and grey? Not equal this color and this color?
Sent from my iPad using Tapatalk
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks