Hi,
Colorindex=3 is RED, colorindex=46 is ORANGE (but they look very
similar) so it will be worthchecking the activecell is really what you think
it is..

I did your tests and found no problem.



"R.VENKATARAMAN" wrote:

I searched in googles groups search I could not get satisfactory answer.

in the inermediate window if I type

activecell.inteiro.colorindex=3 the cell turns red (i.e filled with red
color)

in the same window if I type

?activecell.interior.colorindex
it gives result as
46

In a sub If I use a statement
if activecell.interior.colorindex=3 then -------------
it does not receognise that the cell color is red

But if I type
if activecell.interior.colorindex=46 then -------
it works.

clarifications sought. thanks