Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I print a specified page from several worksheets in Exce.
I want to print a page from several worksheets (for example page 4 from 100
worksheets). Any suggestions? Excel 2000 doesn't have the collection option and I can't seem to figure out how to get "repeat" in a macro (so it would select the next sheet and print). |
#2
|
|||
|
|||
'/=================================================/
Sub TestPage4Print() Dim wksht As Worksheet On Error Resume Next 'print page 4 of all worksheets in the workbook For Each wksht In Worksheets wksht.PrintOut _ From:=4, To:=4, Copies:=1, Collate:=True Next wksht ' OR 'print page 4 of various worksheets in the workbook Worksheets("Sheet1").PrintOut _ From:=4, To:=4, Copies:=1, Collate:=True Worksheets("Sheet3").PrintOut _ From:=4, To:=4, Copies:=1, Collate:=True Worksheets("Sheet7").PrintOut _ From:=4, To:=4, Copies:=1, Collate:=True End Sub '/=================================================/ HTH, Gary Brown "jastmaine" wrote: I want to print a page from several worksheets (for example page 4 from 100 worksheets). Any suggestions? Excel 2000 doesn't have the collection option and I can't seem to figure out how to get "repeat" in a macro (so it would select the next sheet and print). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
print selected sections on the same page | Excel Discussion (Misc queries) | |||
Getting rid of 2nd Page on Print. | New Users to Excel | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) | |||
how to print a row on the bottom of every page | Excel Discussion (Misc queries) |