Thread: Set background color of a cell in VBA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Set background color of a cell in VBA
Cindy,

Try something like the following.

Range("A1").Interior.ColorIndex = 6 'yellow


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


"Cindy" wrote in message
...
Anyone know how to change the background color of a cell
in Excel 2000 VBA code? Thank you

Cindy


Reply With QuoteReply With Quote