Simple VBA question

[BlueMonkey]

Hi

Straight to the point - can you use VBA to return the colour index of the background of a cell. So if cell A1 was "painted" red, can you have VBA return 3 (the colour code for red).

Thanks in advance B.M.

 

[GlennUK]

You mean like :

Selection.Interior.ColorIndex

Glenn.

 

[BlueMonkey]

LOL - like, that's exactly what I mean. I had been running down the "ActiveCell" path.

Cheers B.M.