Hide Row based on Cell Value on Multiple Sheets

I'm after some help with a macro to hide rows where a specific value appears in a column range but on multiple worksheets.

Some of my worksheets are named AP, BG, CK, DR, EF (there are around 20 more).

The macro should check H2:H101 of each worksheet and hide the row if it contains value 3.

Any help much appreciated.

Maybe:

Please Login or Register  to view this content.

Thanks for this but it only hides the rows that meet the criteria on one worksheet. Unusually it's not the first worksheet as I would have expected.

hi xybadog, option

Please Login or Register  to view this content.

Originally Posted by watersev

hi xybadog, option

Please Login or Register  to view this content.

Thanks, but I don't really want to have to use an input as the value will always be 3 in rows that I want hidden.

Out of interest, how is this invoked? I added the code and saved, I ran it but it didn't hide rows as required and when I closed and reopened the workbook nothing happened.

Originally Posted by watersev

hi xybadog, option

Please Login or Register  to view this content.

Thanks, but I don't really want to have to use an input as the value will always be 3 in rows that I want hidden.

Out of interest, how is this invoked? I added the code and saved, I ran it but it didn't hide rows as required and when I closed and reopened the workbook nothing happened.

Try:

Please Login or Register  to view this content.

This worked. Thanks John.

You're welcome. Glad to help out and thanks for the feedback.