View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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/