Printing multiple sheets.
 

You guys are so helpful. This is my current dilemma.

I have already set up 3 different worksheets within one workbook.
have already done the page setup and make all my margins and such loo
perfect.

My macro stuff resides on the 4th sheet of the workbook. what I woul
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

Printing multiple sheets.
 

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/

Printing multiple sheets.
 

Thanks again Ron. You are the best

--
Message posted from http://www.ExcelForum.com