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.
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