Hello fine people,
I am trying to hide rows depending on if there is "data" entered into a cell. The problem is that the code I have is looking at the cell and seeing the formula in the cell and does not think it is empty. Below is what I am trying to use. It would work perfectly if it did not see the cell as not empty.
Any suggestions?
With ActiveSheet
On Error Resume Next
.Columns("T").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
.PrintOut
.Columns("T").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = False
On Error GoTo 0
End With
Bookmarks