How can I get RGB color values?

  • Thread starter Philip Reece-Heal
  • Start date
P

Philip Reece-Heal

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
 
P

Philip

Many thanks Chip
Plenty of stuff to get me to where I was wanting to go and some way
further

All the best
Philip

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Get a color name from any RGB combination? 50
Set text color to interior color 4
Change colour of multiple shapes in a Chart???????? HELP! 4
I need help with macro 3
Changing Cells depending on data entered in other cells 1
Duplicate declaration in scope 2
Generating an RGB color spectrum based on cell values (XL03) 10

Top