Thread: Fill Color? Background Color?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Bigelow Mark Bigelow is offline
external usenet poster
  
Posts: 55
Default Fill Color? Background Color?
Instead of:

WSRange.Font.BackGround = color (hex number)

try:

WSRange.Interior.ColorIndex = (find the colorindexes in VBA help)

or

WSRange.Interior.Color = RGB(255, 0, 0) ' For red

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote