Hide Row if Column B=0

[Nate5452]

Of course this has probably been asked before and I have searched, but I have tried those codes and they haven't worked. I have attached a spreadsheet, and of course column A and B go for a couple hundred rows, but I would like to hide the row if column B=0 in that particular row


thanks
Nate

[jasoncw]

Here is a simple procedure you can run to hide all rows on the active sheet where column B = 0.

Please Login or Register  to view this content.

HTH

Jason

[VBA Noob]

Couple of other options

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

[mikerickson]

Here's a no loop option

Please Login or Register  to view this content.