cell colour change
 

could some one please tell me how in a visual basic macro i can change the
background colour of a cell.

activecell.interior.colorindex = 3

sets it to red

--
HTH

Bob Phillips

"anthony" wrote in message
...
could some one please tell me how in a visual basic macro i can change the
background colour of a cell.

Hi Anthony,

You can try:

ActiveCell.Interior.ColorIndex = x

where x is the colour reference (6 is yellow)

Hope this helps

Warm regards

Sunil Jayakumar

"anthony" wrote in message
...
could some one please tell me how in a visual basic macro i can change the
background colour of a cell.



www.ayyoo.com/credit-cards.html