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

With Sheets("Sheet1") And Sheets("Sheet2")
     
     .Range("B3").Value = 4

End With
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.