ColourIndex not working

matthewh · May 8th, 2002, 05:58 AM

can anyone tell me why

Application.Goto reference:="DOCUMENTS"
With Selection.Interior
.ColorIndex = 40
.Pattern = xlSolid
End With

won't work when

Application.Goto reference:="DOCUMENTS"
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With

does work? It's a from of error checking. Highlights an area in red if the values are incorrect, but I need to set it back to clear via an initialisation sub. I tried xlColorIndexNone, but that doesn't work either. I get error 1004 - unable to set the ColorIndex of the interior class.

Russell · May 8th, 2002, 06:30 AM

To set it back to clear use

Application.Goto reference:="DOCUMENTS"
With Selection.Interior
.ColorIndex = xlnone
.Pattern = xlnone
End With

Russell

matthewh · May 8th, 2002, 06:47 AM

ok, I tried that, but get same error message, but also the value of xlNone is now -4142 at the code break point. Is that correct?

Mudface · May 8th, 2002, 06:49 AM

Does xlColorIndexAutomatic work?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 05:58 AM	#1
matthewh New Member Join Date: Mar 2002 Posts: 34	can anyone tell me why Application.Goto reference:="DOCUMENTS" With Selection.Interior .ColorIndex = 40 .Pattern = xlSolid End With won't work when Application.Goto reference:="DOCUMENTS" With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With does work? It's a from of error checking. Highlights an area in red if the values are incorrect, but I need to set it back to clear via an initialisation sub. I tried xlColorIndexNone, but that doesn't work either. I get error 1004 - unable to set the ColorIndex of the interior class.

May 8th, 2002, 06:30 AM	#2
Russell New Member Join Date: Mar 2002 Posts: 39	To set it back to clear use Application.Goto reference:="DOCUMENTS" With Selection.Interior .ColorIndex = xlnone .Pattern = xlnone End With Russell

May 8th, 2002, 06:47 AM	#3
matthewh New Member Join Date: Mar 2002 Posts: 34	ok, I tried that, but get same error message, but also the value of xlNone is now -4142 at the code break point. Is that correct?

May 8th, 2002, 06:49 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Does xlColorIndexAutomatic work?