Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fills page number of all sheets in current workbook
Hi,
I have VBA code in Excel 2003 that fills page number of all sheets in current workbook in footers for print. I've noticed that if there's a multi-pages "microsoft word document" object in sheets, the page number can't be counted exactly. If I count page breaks in full screen mode (xlPageBreakFull), the page numbers are discontinuous;if I count page breaks in print-erea mode (xlPageBreakPartial), there are repeated numbers between the sheet with a multi-pages "microsoft word document" object and the next sheet。 Has anyone else experienced this issue? Any ideas on what could be causing this. Any thoughts would be greatly appreciated. Thanks. Best regards, dapanpan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding current printer page number | New Users to Excel | |||
How to display current page number in any cell of that page. | Excel Discussion (Misc queries) | |||
How to create a function that fills the current date in an adjoining cell | Excel Programming | |||
Can we get the current page number, or just row number? | Excel Programming | |||
How to write macro for entering mm/yy where it fills to current mm/yy | Excel Programming |