Thread: Print many worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graeme at Raptup Graeme at Raptup is offline
external usenet poster
  
Posts: 16
Default Print many worksheets

Thanks,
I ended up using Sheets(Array(....



"Ron de Bruin" wrote:

Hi Graeme

You can use a array

Sheets(Array("Sheet1", "Sheet3")).PrintOut
'all sheets in the array

Or print the selected sheets

ActiveWindow.SelectedSheets.PrintOut
'print all selected sheets


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Graeme at Raptup" wrote in message
...
Hi,
I want to add a button that prints many, but not all, worksheets.
How do I go about this?

Thanks,

Graeme


Reply With QuoteReply With Quote