| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I print only specified pages from a print range such as pages 1,3,4,6
Is there a way to print only part of the pages in a print
range. For instance I want to print the travel page for task2 only if there are travel costs. I know how to check the value of the travel costs, but is there a way to leave this sheet out if there are no costs. I'm wondering if there is a way to get the range reference for each page and then print only the ones I want. Any suggestions would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I print only specified pages from a print range such as pages 1,3,4,6
Mel,
Worksheets("Name").PrintOut From:=1, To:=1 Worksheets("Name").PrintOut From:=3, To:=3 Worksheets("Name").PrintOut From:=4, To:=4 Worksheets("Name").PrintOut From:=6, To:=6 Obviously, you would want to add logic and looping, along the lines of For i = 1 To 6 If SomeCondition = True Then Worksheets("Name").PrintOut From:=i, To:=i End If Next i HTH, Bernie MS Excel MVP "Mel" wrote in message ... Is there a way to print only part of the pages in a print range. For instance I want to print the travel page for task2 only if there are travel costs. I know how to check the value of the travel costs, but is there a way to leave this sheet out if there are no costs. I'm wondering if there is a way to get the range reference for each page and then print only the ones I want. Any suggestions would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I print only specified pages from a print range such as pages 1,3,4,6
Thanks a bunch.
-----Original Message----- Mel, Worksheets("Name").PrintOut From:=1, To:=1 Worksheets("Name").PrintOut From:=3, To:=3 Worksheets("Name").PrintOut From:=4, To:=4 Worksheets("Name").PrintOut From:=6, To:=6 Obviously, you would want to add logic and looping, along the lines of For i = 1 To 6 If SomeCondition = True Then Worksheets("Name").PrintOut From:=i, To:=i End If Next i HTH, Bernie MS Excel MVP "Mel" wrote in message ... Is there a way to print only part of the pages in a range. For instance I want to print the travel page for task2 only if there are travel costs. I know how to check the value of the travel costs, but is there a way to leave this sheet out if there are no costs. I'm wondering if there is a way to get the range reference for each page and then print only the ones I want. Any suggestions would be appreciated. Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
| How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) | |||
| ?set up a print range to cover multiple pages in excel | Excel Worksheet Functions | |||
| how do I print a range without printing the blank pages? | Excel Discussion (Misc queries) | |||
| print range name over multiple pages | Excel Programming | |||
Linear Mode
