Try something like

Range("A1").Interior.ColorIndex = 3

See ColorIndex in Help for more information.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"owl527"
wrote in message
...

Hi,
how do I set the color of a sell using VB? please let me know.
Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread:
http://www.excelforum.com/showthread...hreadid=488595