insert sheet name into a macro by cell reference

[Markarmi]

Hi,

Macros are not my strong point, but id like to set up an auto print option on a report ive built
however the print option would only be relevant to the specific months tab
e.g Aug (tab name)

I know the code to name a specific sheet is Sheet ( "aug").select

but I don't want to change the macro every month so was hoping to drive the macro from a cell reference which I would have set as a list

is it possible to have the "aug" as a cell reference ? so it would switch print options driven by the tab name change

sorry if ive not explained this very well

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Markarmi]

Perfect, many thanks John

[JOHN H. DAVIS]

You're welcome. Glad to help out.