Faster macros for hiding/unhiding rows?

Hello,

I'm pretty new to VBA, so please forgive me if this is a noob question. I've been researching online for macros that will hide rows if certain cells in them are blank or 0, and then I've created macros to unhide those same rows again. I've found some that work for me -- the only problem is that the macros run quite slowly in some spreadsheets. I will post the macros I'm using below; would you please let me know if you see anything that could be adjusted to make them faster, or if you know of a more efficient macro which would accomplish this?

Hide Empty Rows

Please Login or Register  to view this content.

Unhide Rows

Please Login or Register  to view this content.

Thank you so much for your help!

How is the code slow when it loops only from intStartRow = 11 intEndRow = 28?
You are not looping through thousands rows.
Filering code is supposed to be fast

I appreciate your help with this!

It may be that the answer to my question is I need a faster computer (my machine is pretty old), or that I have an unrealistic expectation of the speed I should be seeing. It definitely doesn't seem fast to me... it takes about 4 seconds for the code to loop through row 11-28.

Try this one. I cut out some of the lines

Please Login or Register  to view this content.

it takes about 4 seconds
You meant 40 seconds.
I think 4 seconds is normal time for any VBA code to run

Thank you, that's good to know. No, I meant 4 seconds. The other macros I'm running all run in under a second, so it seemed like these are slow by comparison.

I tried using your compressed code but it did not work for me.

After trimming the document of proprietary information in order to create a sample file, it seems to be running faster, so the problem may just be that it's an unwieldy spreadsheet, with lots of formulas tying to other tabs. However, I have attached the sample file for your thoughts.

Thanks again for your help with this!

Hi Teaorchid,

I just checked your sample attached document.
If you add "Application.ScreenUpdating = False" at the beginning of the code
and at the last you write Application.ScreenUpdating = True.

When u don't add this code in your macro, application may run little bit of slow.

http://excelsenior.com/