VBA To Filter Out Blank Cells in a Selected Column

[Manish B Jain]

Can someone help me write a small macro to help me weed out the blank cells in my selected column show only the ones with content in it.

 

[Hui]

Have you tried making a table and applying a Filter?

 

[p45cal]

Sub blah()
    Selection.EntireColumn.AutoFilter
    Selection.EntireColumn.AutoFilter 1, "<>"
End Sub

 

[Matther101]

I need a solution for this too. Is it possible to do this without code? I can use a table an filter, but when I print the spaces remain.