Printing Multiple Named Worksheets

[masterp]

Hi All,

I would like to print a selected number of named worksheets in excel (example sheet1, sheet2 and sheet3) and would like to automate this via a button.

Assistance would be greatly appreciated.

Regards

Master P

 

[Andrew Poulsom]

Example:

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintOut

 

[masterp]

I am getting Run-time Error '9'

Subscript out of range

 

[Andrew Poulsom]

Do you have worksheets named Sheet1, Sheet2 and Sheet3?

 

[masterp]

Do you have worksheets named Sheet1, Sheet2 and Sheet3?

Hi I have sheets named different and I copied them exactly as they appear in Excel but still not working.

 

[Andrew Poulsom]

Please post your code that's not working.

 

[masterp]

Hi Andrew,

Appologies

There was a blank space in the name hence the issue.

Many thanks for your help

Regards

Master P