Hide rows only on specific worksheets

Hi All -

I need help with VBA code to hide rows but only on specific worksheets. I'm not sure if a "case" statement is the way to go about acheiving this,but I tried it and it would only work on the first sheet. I know I'm missing something, just can't figure out what.

The following code should be performed on all worksheets:

Please Login or Register  to view this content.

And this code should only be performed on these worksheets: "Policy Administration", "Policy Issue", "App Processing Services", "Underwriting Decisions", "Initial Claims", "Ongoing Claims Administration", "Claims Examinations"

Please Login or Register  to view this content.

Try this for your first part:

Please Login or Register  to view this content.

How many worksheets are there and which ones do not require the second activity.

For the second code, try this...........

Please Login or Register  to view this content.

Run the following on a sample set:

Please Login or Register  to view this content.

MissaLissa
Try this:

Please Login or Register  to view this content.

MissaLissa
Try this:

Please Login or Register  to view this content.

Glad to help you. Thanks for the feedback.