Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook with around 70 sheets in it
Each sheet, when printed, covers around 2-3 pages. I only need to print off page 1 of each sheet I tried the following macro, but it printed just the one sheet 70 times Could someone suggest a change so it does all sheets, and not just the one Sub TestPrint( Dim ws As Workshee For Each ws In Worksheet On Error GoTo ActiveSheet.PrintOut From:=1, To:= Next w End Su TIA Bobby |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SAVING large worbook | Excel Discussion (Misc queries) | |||
Error message help with linked worbook | Excel Discussion (Misc queries) | |||
Open Worbook and Disable Macros | Excel Discussion (Misc queries) | |||
Shared Worbook Accessible on an Intranet | Excel Discussion (Misc queries) | |||
Increment linked worbook | Excel Discussion (Misc queries) |