With statements with multiple sheets

[Masact]

Is it possible to have one with statement that affects more than one sheets at a time? For example (this is really simple):

Please Login or Register  to view this content.

I am getting an error when trying this and can't seem to find a way around it.

Reason I ask is because I have a good deal of code that is setting print ranges on one tab, and now I have two of these same tabs, and would like to try to avoid having the same with statement twice, once for each sheet. Any ideas??

Thanks in advance.

[realniceguy5000]

Based on your script example this is what I came up with?

Please Login or Register  to view this content.

[Leith Ross]

Hello Masact,

The With statement can be applied only to a single object. You could use realniceguy5000's solution or use a loop.

Loop through Sheets

Please Login or Register  to view this content.

[Charles]

Hi,

Also try

Please Login or Register  to view this content.