I have a code that hides entire rows if cells in range A23:A72 are blank, but it doesn't seem very efficient speed wise since it goes cell by cell. Is there a faster way to write this code?
Thank you for the assistance!
Please Login or Register to view this content.
Use AutoFilter. Record a macro while you filter on column A.
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
@TMS - I recorded a macro and it filters for blanks, but I want to remove the filter at the end of the macro without those blank rows showing up again. Is that possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks