Column A has formulas that pull information from other tabs. So that it isn't cluttered up, I have it returning "" if the formula is FALSE. However, it does not seem to be recognizing the "" value. Is it even possible to do or should I be trying something else? Any help is much appreciated.
Thx!
Thx!
Code:
Sub PostCondense()
Dim LastRow As Long
Dim Rng As Range
LastRow = Range("A38").End(xlUp).Row '
Set Rng = Range("A8:A" & LastRow) '
Application.ScreenUpdating = False
For Each Cell In Rng
If Cell.Value = "" Then
Cell.EntireRow.Hidden = True
End If
Next Cell
Application.ScreenUpdating = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
End Sub