Hiding/Unhiding Rows

Hi all,

New to the forums, new to VBA, but not new to excel.

I’ve done some research on VBA, and I understand the basics, but I am struggling – which is expected as I continue to learn.

I’ve created a budget where I’m comparing actual numbers to budgeted numbers. I want to hide rows if the cell reveals a zero value. These cells are all formulae based (drawing data from another worksheet).

So for example, if the formulae in column O and P results in a value of 0, I want that corresponding row to be hidden (and unhidden if not equal to 0). Any ideas on how I can do this?

Also, how would I go about activating this macro? Is there any way for this macro to always be running, or is it best to be activated with the click of a shape/button?

Thanks for any input,

I can say one thing logically it will work..
First put one formula on speate column can count only the value > 0 , O ,P like [ =countif(range,">0") ] then put filter on that so wen filter is on you can always see not equal zero .. You can put filter filtering above zero by using macro just record one macro and do one time filter then stop macro so you can do that automatically ...

Best of luck