P Paul Moles Jul 3, 2003 #1 Can Color.Index= refer to a cell value eg (A1) or does it have to be "hard coded" with a value?
B Bernie Deitrick Jul 3, 2003 #2 Paul, No need for hard coding: Range("A2").Interior.ColorIndex = Range("A1").Value HTH, Bernie Excel MVP
Paul, No need for hard coding: Range("A2").Interior.ColorIndex = Range("A1").Value HTH, Bernie Excel MVP
T Thomas Jul 3, 2003 #3 [a1].Interior.ColorIndex = [a1].Value This will work when A1 holds a valid colorindex number,if not it will generate an error.
[a1].Interior.ColorIndex = [a1].Value This will work when A1 holds a valid colorindex number,if not it will generate an error.
