Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
Hi,
Would you please show me how to print only the old page numbers ? Ex: In the page break view, I see that the file has 100 pages, but I only want to print page 1,3,5..... Please help Thanks Chi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
Hi,
Select print, print range check page, enter 1 to ?? your page number "Chi" wrote: Hi, Would you please show me how to print only the old page numbers ? Ex: In the page break view, I see that the file has 100 pages, but I only want to print page 1,3,5..... Please help Thanks Chi |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
Hi Eduardo,
Thank you for the respond! I selected office button/Print/under print range option, I checked page option and entered From 1 to 3,5,7. I got an error message. Please help Chi "Eduardo" wrote: Hi, Select print, print range check page, enter 1 to ?? your page number "Chi" wrote: Hi, Would you please show me how to print only the old page numbers ? Ex: In the page break view, I see that the file has 100 pages, but I only want to print page 1,3,5..... Please help Thanks Chi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
1-3, 5, 7 will print 1, 2, 3, 5, 7. Use the dash instead of the word to.
-- HTH... Jim Thomlinson "Chi" wrote: Hi Eduardo, Thank you for the respond! I selected office button/Print/under print range option, I checked page option and entered From 1 to 3,5,7. I got an error message. Please help Chi "Eduardo" wrote: Hi, Select print, print range check page, enter 1 to ?? your page number "Chi" wrote: Hi, Would you please show me how to print only the old page numbers ? Ex: In the page break view, I see that the file has 100 pages, but I only want to print page 1,3,5..... Please help Thanks Chi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
Try this macro from Ron de Bruin's site.
Sub Print_Odd_Even() Dim Totalpages As Long Dim StartPage As Long Dim Page As Integer StartPage = 1 '1 = Odd and 2 = Even 'Or use the InputBox suggestion from Gord Dibben 'StartPage = InputBox("Enter 1 for Odd, 2 for Even") Totalpages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") For Page = StartPage To Totalpages Step 2 ActiveSheet.PrintOut from:=Page, To:=Page, _ Copies:=1, Collate:=True Next End Sub Gord Dibben MS Excel MVP On Wed, 23 Sep 2009 10:43:01 -0700, Chi wrote: Hi, Would you please show me how to print only the old page numbers ? Ex: In the page break view, I see that the file has 100 pages, but I only want to print page 1,3,5..... Please help Thanks Chi |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
Hi Jim,
Thank you for the respond, but I thought you both look at Word print option. Please correct if I am wrong. In Excel/ under Print dialog box/ Print range/ page(s ) option- From ..... To..... text boxes. Please advice Thank you! Chi "Jim Thomlinson" wrote: 1-3, 5, 7 will print 1, 2, 3, 5, 7. Use the dash instead of the word to. -- HTH... Jim Thomlinson "Chi" wrote: Hi Eduardo, Thank you for the respond! I selected office button/Print/under print range option, I checked page option and entered From 1 to 3,5,7. I got an error message. Please help Chi "Eduardo" wrote: Hi, Select print, print range check page, enter 1 to ?? your page number "Chi" wrote: Hi, Would you please show me how to print only the old page numbers ? Ex: In the page break view, I see that the file has 100 pages, but I only want to print page 1,3,5..... Please help Thanks Chi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel |