cell colour change

[anthony]

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

 

[Bob Phillips]

activecell.interior.colorindex = 3

sets it to red

 

[Sunil Jayakumar]

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

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