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,