Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing several worksheets
I have several workbooks with differently named worksheets. The one thing
they all have in common is that sheet no 1 is called "Formula" and the last one called "End". I'm looking for a macro to move between sheets and print them all between the first and the last sheet. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing several worksheets
Hi
This will print all of the sheets in an open workbook Sub printer() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.PrintOut Next End Sub regards Paul On Feb 11, 7:40*am, fredrik wrote: I have several workbooks with differently named worksheets. The one thing they all have in common is that sheet no 1 is called "Formula" and the last one called "End". I'm looking for a macro to move between sheets and print them all between the first and the last sheet. Can anyone help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing several worksheets
Try this idea
Sub PrintSheetsByIndexSAS() fs = Sheets("formula").Index ls = Sheets("end").Index 'MsgBox fs 'MsgBox ls For i = fs To ls Sheets(i).PrintPreview Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "fredrik" wrote in message ... I have several workbooks with differently named worksheets. The one thing they all have in common is that sheet no 1 is called "Formula" and the last one called "End". I'm looking for a macro to move between sheets and print them all between the first and the last sheet. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Most but not all worksheets | Excel Discussion (Misc queries) | |||
Printing several worksheets at once | Excel Discussion (Misc queries) | |||
printing worksheets | Excel Discussion (Misc queries) | |||
Printing worksheets | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |