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
Rupesh Tripathi - 11 Apr 2007 17:14 GMT
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,
[quoted text clipped - 10 lines]
>
> silas
silas - 11 Apr 2007 17:33 GMT
That did it. Thank you much.
silas
> Use autofilter, filter blanks and delete all the rows that get
> displayed.
[quoted text clipped - 15 lines]
>>
>> silas