Macro to Hide/Unhide Cells

I am wanting to create a macro (that will be attached to a button) where I can hide/unhide rows based on if they have a zero value in a certain column. I have attached an example workbook which shows two separate value sets (rows 10-30 and 34-59) where if there is zero value in column G, I want to be able to run the macro to hide the rows with a zero. I also want to be able to run the same macro to unhide, so sort of like an on/off switch.

Any help creating this macro would be greatly appreciated!

Thanks!

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hey Greg!

This seems to have worked perfectly, just as I wanted. Thanks for the input on this!

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Regards,

Greg M

Hi again,

Sorry about the delay in getting around to this.

The "PerformToggle" routine has been rewritten as shown below, and appears to do what you need.

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M