Is there a way of telling a macro to run in the specified sheet, without using:

Worksheets("Sheet1").<property

Can I use a refrence like this.<property or me.<property?

I'm looking to do some formatting of a sheet in VBA, setting the page
orientation, and Print Area. The name of the sheet may change from instance
to instance though, so I don't want to put in a static page name.

Thank you in advance for any help offered.