What is the cell colour?

lotsbg

Board Regular
Joined
Mar 8, 2004
Messages
108
Any way to work out what a particular cell colour is?
I have this file that has background cell colours, and basically I want to delete all the rows which have a particular colour.....I don't know what the colour is, so I can't do an if statement....

anyone with any ideas? much appreciated
 

lotsbg

Board Regular
Joined
Mar 8, 2004
Messages
108
Not sure. They are a file from another source with the cell already coloured.
 

lotsbg

Board Regular
Joined
Mar 8, 2004
Messages
108
managed to work it out using the following:

For Count = 1 To 100
If ActiveCell.Interior.ColorIndex = Count Then Exit For
Next Count

Thanks for your help
 

Forum statistics

Threads
1,077,782
Messages
5,336,291
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top