Selecting entire row for special cells
Posted by Wowblagger on November 23, 1999 6:12 AM
I am trying to hide all rows where cell values are empty. Rather than looping though each row, I am using the special cells method, as below:
'RANGE("a1:a7").SpecialCells(xlBlanks).Interior.Color = RGB(255, 0, 0)
This works fine, changing the cell colour to red for those cells which are empty. But when using the entirerow property for the same range as below:
'RANGE("a1:a7").SpecialCells(xlBlanks).EntireRow.Hidden = True
This simply hides all rows in the specified range.
The data is the same in both cases, I am comparing like with like.
Is there an elegant way round this?