I'm using Excel 2016 and I'm using VBA to get the colorindex of cells using
LeftColorIndex = wshScores.Range("D" & lRow).Offset(0, -1).Interior.ColorIndex
in a "for loop".
The sheet is set to not show grids.
Some blank cells return colorindex=2 and other show colorindex = -4142.
Visually they're 'white' but am I missing something.
What is the difference?
Thanks
Chuck
LeftColorIndex = wshScores.Range("D" & lRow).Offset(0, -1).Interior.ColorIndex
in a "for loop".
The sheet is set to not show grids.
Some blank cells return colorindex=2 and other show colorindex = -4142.
Visually they're 'white' but am I missing something.
What is the difference?
Thanks
Chuck
Last edited: