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.
WKPlease Login or Register to view this content.
Bookmarks