Hide Zero rows

[WhiteKelso]

Hi everyone,

I have a seemingly easy task which I need help a more efficient macro to do for me. Here's the scenario:

My column C (rows 1 to 10) has the following numbers:
1
1
1
1
1
1
0
0
0
0


The macro should hide rows 2, 4 and 6 then all zeros after that. I had a Do While macro made, but it runs verrrrrrry slow. Just wondering if another trick would do the job more efficiently.

Thanks and I'm always grateful for the help this site has given me.

WK

Please Login or Register  to view this content.

[VBA Noob]

Your title says delete and your post says hide so I gone with the post version

Maybe

Please Login or Register  to view this content.

VBA Noob

[WhiteKelso]

Your title says delete and your post says hide so I gone with the post version

Maybe

Please Login or Register  to view this content.

VBA Noob

Sorry for the mix up. My intention was to hide the rows.

Thank you very much. I appreciate your help.

WK

[VBA Noob]

Glad it helped

I've amended your title

VBA Noob