Need a formula for returning the value of the cell shading in a cell

  • Thread starter Thread starter Jesse O
  • Start date Start date
J

Jesse O

Is there a forumla I can use to return the numerical value of what color
a cell is shaded or its background color is?

Say I have a cell B24, and i want to set cell D24 equal to the numerical
value (of the background or shading color) of B24.

Is this even possible?
 
Try,

Sub colourtest()
s = ActiveCell.Interior.ColorIndex
MsgBox s
End Sub

HTH's
Russell.
 
Back
Top