Delete 'non-blank' rows...

  • Thread starter Thread starter Rupesh Tripathi
  • Start date Start date
R

Rupesh Tripathi

Use autofilter, filter blanks and delete all the rows that get
displayed.
 
Hi. I've pasted data into my worksheet that leaves every other row empty. I
need to delete the empty rows but sorting messes up the order,
GoTo/Special/Blank won't work and neither will several DeleteEmptyRow macros
I've tried.

I applied the ISBLANK function to the empty rows and it returned a FALSE
value so something unseen is in those rows. No matter, I still need to
delete them.

Any ideas?

Thanks,

silas
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove blank rows 3
Filtering in XL2003 -- where did filter by blanks go, pls? 5
Autofilter updating automatically 2
Eliminate blanks while copy row and transpose 11
skipping blanks? 3
Why no "insert copied cells"? 1
Autofilter Automatically Update 1
Lookup formula help 1

Back
Top