Range("A1").Interior.ColorIndex=xyz does not work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iwl - 07 Dec 2007 16:16 GMT

Hello Group,

I try to set Cell Background-Color with
Range("A1").Interior.ColorIndex=xyz
but does not work while I can read out the value
and it is different when I set it with Cell Format
in Excel manualy if I set it from vba it isn't so
red back again

Reply to this Message

Jim Thomlinson - 07 Dec 2007 16:30 GMT

What do you mean by does not work. Does it throw an error or does it just not
do anything. Since you do not specify a worksheet in the code line are you
sure it is acting on the correct worksheet???

Worksheets("Sheet1").Range("A1").Interior.ColorIndex=34
might fix your problem.

Signature

HTH...

Jim Thomlinson

> Hello Group,
>
[quoted text clipped - 4 lines]
> in Excel manualy if I set it from vba it isn't so
> red back again

Reply to this Message