How can I delete or eliminate all blank rows from a worksheet?
How can I delete or eliminate all blank rows from a worksheet?
Use Autofilter to show just the blank rows and then select your range of rows and delete them.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Autofilter is not working - blank rows not showing up - data scattered
I use this
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Thanks Tom ! this is what I was looking at.
If you select the whole range on data before switching Autofilter on it should work.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks