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.
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.