I have a macro to delete all blanks rows in Col A up to the row before the first value
The Macro does not delete any of the blank rows before the first value
Kindly test my macro and amend
Please Login or Register to view this content.
I have a macro to delete all blanks rows in Col A up to the row before the first value
The Macro does not delete any of the blank rows before the first value
Kindly test my macro and amend
Please Login or Register to view this content.
This fixes your code, but it's not the best way:
You would be better switching on AutoFilter, filtering on blanks in column A, then deleting the visible rows. Only important if there's lots of data. You should be able to Google a solution using AutoFilter if you need it.Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Many thanks Trevor
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks