Font.ColorIndex
Hi,
It will return that if the colorindex is xlautomatic
Try this
Range("a1").Font.ColorIndex = xlAutomatic
Debug.Print Worksheets("Sheet").Range("a1").Font.ColorIndex
Mike
"kirkm" wrote:
Does anyone know why
debug.print Worksheets("Sheet").Range("C955").Font.ColorIndex
sometimes returns a negative 4 digit number (e.g. -4105)
when it should return something else entirely, like a 7?
Thanks - Kirk
|