Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print 3 Worksheets
Hi there, I need a macro to print three worksheets (say a, b, and c) within a workbook... Thanks guys! D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print 3 Worksheets
Use the macro recorder.
-- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Darin Kramer" wrote in message ... Hi there, I need a macro to print three worksheets (say a, b, and c) within a workbook... Thanks guys! D *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print 3 Worksheets
Thanks - I was trying to write it in VBA, but Macro is easier. What I had below wasnt working Sub Print() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name = "a" Then ws.PrintOut Copies:=1, Collate:=True End If Next End Sub *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print 3 Worksheets
Use this
Sheets(Array("Sheet1", "Sheet", "Sheet3")).PrintOut -- Regards Ron de Bruin http://www.rondebruin.nl "Darin Kramer" wrote in message ... Thanks - I was trying to write it in VBA, but Macro is easier. What I had below wasnt working Sub Print() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name = "a" Then ws.PrintOut Copies:=1, Collate:=True End If Next End Sub *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to print a workbook but worksheets have diff print areas | Excel Discussion (Misc queries) | |||
how to print 2 worksheets at once, one being a ref. to the other | Excel Discussion (Misc queries) | |||
How to PRINT all worksheets at once | Setting up and Configuration of Excel | |||
How do I print a workbook in but only print selected worksheets? | Excel Discussion (Misc queries) | |||
print out of worksheets | Excel Worksheet Functions |