How can I get RGB color values?

  • Thread starter Thread starter Philip Reece-Heal
  • Start date 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
 
Phillip,

Well, almost everything.
Forgot to mention Chip's site too

John
 
Many thanks John
Plenty of stuff to get me to where I was wanting to go

All the best
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
 
You must log in or register to reply here.

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

#Value! error when using ActiveCell.Interior.Color 1
Set text color to interior color 4
I need help with macro 3
Can Vba workout if a selection is part of a group? 0
Change colour of multiple shapes in a Chart???????? HELP! 4
Excel VBA 1
Macro Error that I connot figure out 7
Changing Cells depending on data entered in other cells 1

Back
Top