Use this
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintOut
--
Regards Ron de Bruin
http://www.rondebruin.nl
"sungen99 " wrote in message ...
You guys are so helpful. This is my current dilemma.
I have already set up 3 different worksheets within one workbook. I
have already done the page setup and make all my margins and such look
perfect.
My macro stuff resides on the 4th sheet of the workbook. what I would
like to happen when you press the "go" button is for worksheet 1, 2,
and 3 to print.
Can anyone tell me how this would be done?
Thanks again in advance.
---
Message posted from http://www.ExcelForum.com/