How to hide rows based on cell value, row range is dynamic.

I'm pretty new to VBA so my knowledge is pretty low. I've been searching various forums for this, but can't modify the code I've see to fit what I'm doing.

I have a spreadsheet that has a dynamically changing number of rows. I need to hide(or filter out) all rows with a cell value not equal to 0 in column G starting at row G4 down(G3 is my header row).

I already have several iterations of various For/each and Case statements but can't modify them correctly to apply to my situation.

Any help would be greatly appreciated.


Thanks,

See if this code helps:

Please Login or Register  to view this content.

Put it in your the object of whichever sheet you are using, not a module. This will run every time the sheet is updated. Let me know how this works.

Put this in a module:

Please Login or Register  to view this content.

Let me know if this works.

I got it to work:

Please Login or Register  to view this content.

Thanks,