Hiding rows/columns on various worksheets

[Nicola13]

Hi there,

I currently have the code below to hide various columns and rows on different sheets:

Please Login or Register  to view this content.

If the user deletes one of the sheets this causes problems.
Is there any way to say hide rows
"47:63,66:82,85:101,104:120,123:139,142:158,161:177,180:196,199:215,218:234,237:253,256:272,275:291,294:310,313:329,332:348,351:367,370:386,389:405,408:424,427:443,446:462,465:481,484:500,503:519" on "Cover Sheet" then hide columns "K:S" on all other sheets.

[Bishonen]

Please Login or Register  to view this content.

[Nicola13]

Getting a compile syntax error for the following line

Please Login or Register  to view this content.

[Trebor76]

Hi Nicola13,

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert

[Bishonen]

please change it to

Please Login or Register  to view this content.

[Nicola13]

Thanks Trebor76

[Trebor76]

You're welcome

[Nicola13]

Trebor76 looking for your help with adjusting the code you gave me. I've tried the code below but getting a compile error: End With without with?Any suggestions?

Please Login or Register  to view this content.