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
 
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
 
Back
Top