Resolved >>> Hide blank rows within a range

[jeff.p]

Hello,

I have this code (compliments of VBA Noob) which hides all blank rows within a range ("Range1") P16:V650
It works great in a new worksheet with little amount data, however within my heavy worksheet, it takes over a minute to compile.

Please Login or Register  to view this content.

I'm currently using this secondary code (provided by shg) which hides all blank rows between two columns, (Range1) & (Range2)

Please Login or Register  to view this content.

Works terrifically in my worksheet, and Is lightning fast.



Is there a way to modify the 1st code for more speed efficiency?
My initial inquiry was to hide blank rows within a Range



thanks for any help.


Jeff

[Ikaabod]

This should speed it up a bit... I just ran it for 6000 rows and took only seconds.

Please Login or Register  to view this content.

Edit: Ran it for 16000 rows and was only able to count to about 15 before it was finished.

[jeff.p]

Speed it up, indeed!

works great!

thanks Ikaabod

jeff