View Single Post
  #3   Report Post  
Sunil Jayakumar
 
Posts: n/a
Default

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