VBA-Hide entire row if cell in column is empty or blank (visually empty but has formula)

[sdoppke]

Hi everyone, well actually the title said it all. I searched for this topic but cant find exactly this case.

So again, looking for script that hides entire row in if a any cell in column A is empty or blanck (has formula)

Thaks a bunch.

sd

 

[shg]

You could use AutoFilter with the criteria "<>"

If it must use VBA, you could record a macro while you do that.

 

[AlphaFrog]

Sub Macro1()
    Dim Lastrow As Long
    Lastrow = Range("A1").Find("*", , xlFormulas, , xlByRows, xlPrevious).Row
    Range("A1:A" & Lastrow).AutoFilter Field:=1, Criteria1:="<>"
End Sub

 

[sdoppke]

Sub Macro1()
    Dim Lastrow As Long
    Lastrow = Range("A1").Find("*", , xlFormulas, , xlByRows, xlPrevious).Row
    Range("A1:A" & Lastrow).AutoFilter Field:=1, Criteria1:="<>"
End Sub

Thanks AlphFrog! im doing something wrong to where im getting an error:
"object variable or with variable not set"

Any ideas?

sd