Delete blank rows after filter - if no blank rows exit sub

Hi all, just need some tweaking on a macro I have that delete's blank rows after a filter.

The rows and in a table named "customer range", the macro works fine - unless there are no blank rows and then it delete's everything.

Please Login or Register  to view this content.

Teh filter checks for blanks in Column A (as all otehr rows should be populated in this column).

Thanks in advance for your help

Hi there, no i get a run time error 6 message saying "overflow" and highlighting the LastRow = Activesheet.............. part

Works a treat - thank you so much