Hi, How about the way to change the color within VBA
J Jacob Skaria Mar 19, 2010 #2 Range("A1:A10").Font.Colorindex = 3 Refer the below for help on Colorindex http://www.mvps.org/dmcritchie/excel/colors.htm
Range("A1:A10").Font.Colorindex = 3 Refer the below for help on Colorindex http://www.mvps.org/dmcritchie/excel/colors.htm
H HuaMin Mar 19, 2010 #3 Thanks Jacob. I put that but I've got this error run-time error '1004': unable to set the ColorIndex property of the font class
Thanks Jacob. I put that but I've got this error run-time error '1004': unable to set the ColorIndex property of the font class
J Jacob Skaria Mar 19, 2010 #4 How did you try that? -- Jacob HuaMin said: Thanks Jacob. I put that but I've got this error run-time error '1004': unable to set the ColorIndex property of the font class Click to expand...
How did you try that? -- Jacob HuaMin said: Thanks Jacob. I put that but I've got this error run-time error '1004': unable to set the ColorIndex property of the font class Click to expand...
