I'm trying to write a function that can change the color of the cell
that calls it. Can anyone tell me why I can read the ColorIndex, but
not set it? Help file says it is read/write, but it appears to be
locked out from writing in a Function.
Function Ctest()
'set color
With Application.Caller.Interior
.ColorIndex = 4
.Pattern = xlSolid
End With
'read back color
Ctest = Application.Caller.Interior.ColorIndex
'why doesn't the color get set???
End Function