Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook with different page number footers
I have a workbook with about 30 tabs, each one with a different table. Some
tables are 1 page long and some are 4 pages long. I want to print the entire workbook so that the table that has 1 page says 1 of 1 and the 4page table says 1 of 4, and so on. However, since I'm using the footer feature, 1 of ?, it just gives me 1 of total number of pages in the workbook. How can I get around this without printing each tab individually? -- Angel Bivins WordAngel Document Design www.wordangel.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook with different page number footers
Hello Angel,
I just received this part of a macro from Dave Peterson, it suits the purpose fine, giving a relaxed paging system for selective/deductive printing. here's a part of the code, yet please dont ask me how to build it because i'm no macroman.! For wCtr = LBound(ArrNames) To UBound(ArrNames) Worksheets(wCtr).PageSetup.CenterHeader _ = "Page " & Worksheets(wCtr).range("A2").value _ & " of " & Format(TotalPages, "#,##0") Next wCtr i think the above means the macro will place a value from A2 into the &[PAGE] field of the header . kinda like that. Others may give more different suggestions. regards, driller -- ***** birds of the same feather flock together.. "Angel Bivins" wrote: I have a workbook with about 30 tabs, each one with a different table. Some tables are 1 page long and some are 4 pages long. I want to print the entire workbook so that the table that has 1 page says 1 of 1 and the 4page table says 1 of 4, and so on. However, since I'm using the footer feature, 1 of ?, it just gives me 1 of total number of pages in the workbook. How can I get around this without printing each tab individually? -- Angel Bivins WordAngel Document Design www.wordangel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Can a header be applied once to a workbook & print on each page? | Excel Worksheet Functions | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
How can I print page 2 of each sheet in a workbook? | Excel Discussion (Misc queries) | |||
Print Workbook Without Page Breaks Between Worksheets | Excel Worksheet Functions |