LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How can I get RGB color values?

mycolor = ActiveCell.Offset(0, 1).Interior.Color
ActiveCell.Value = mycolor

The above code gives me the integer color values (which I don't understand)
for the cell to the right of the active cell and the following code gives me
the color palette numbers:

mycolor = ActiveCell.Offset(0, 1).Interior.ColorIndex
ActiveCell.Value = mycolor

How can I get the RGB color values


Any info gratefully appreciated

Philip


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sum up values only in cells that are color filled? TryingExcel Excel Worksheet Functions 7 April 12th 09 03:34 PM
Find Values in Range Then Color Cue Excel Discussion (Misc queries) 2 October 13th 08 01:58 PM
Sum function when the values in an xls are color coded Angeles Excel Worksheet Functions 2 May 29th 08 03:55 PM
Category color changes when changing values. JanSr Charts and Charting in Excel 0 July 11th 07 09:40 AM
Neg Values in Chart with Diff Color? Will Excel Discussion (Misc queries) 1 December 13th 06 06:06 PM


All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"