Any faster way to delete hidden rows of data

Hi,

I have the following code which i use to delete hidden rows. Unfortunately, its kinda slow........it takes about 86 sec to delete ~ 2749 rows of data. Is there a faster way to delete hidden rows?

Please Login or Register  to view this content.

What i am doing is this.I have a worksheet of data. I am filtering on this data so that after filtering i have what i want to "keep". Those things i dont want to keep are "hidden"....so i am removing the hidden files. And what i am left with is only that which i want to keep.

I would work the other way, i.e. set up your filter so that it hides the rows that you want to keep and then delete the visible cells and then restore the filter. You can do this (manually) by GoTo | Special | Visible Cells, and then you can delete in one operation. You can use SpecialCells in a macro, but I'm not sure of the exact syntax - perhaps you could record a macro while you do it manually.

Hope this helps.

Pete

i will try what you guys suggested. I may have questions about exactly how to do what your suggesting........

thanks jefferybrown,

i thought i understood what you were saying but apparently i did not. I tried your code........IT WORKED GREAT and MUCH MUCH MUCH FASTER than the other way. Your way took about 0.09sec vs about 80seconds the way i was doing it.

thanks.......i will have to review your code in more detail to figure out exactly what is going on.

thanks.