Delete 'non-blank' rows...

S

silas

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
 
Top