Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format last row printed
I have code that sets the border around the printed area prior to printing.
I works fine on a single sheet, but if the print area is over several sheets, the bottom of the border prints on the last page. Is there a way to set the border on each page? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format last row printed
Vince
The only way I know to do that is to first figure out (trial & error) how much of your data will print on one sheet if that range has a border. Then setup a macro to sequentially place the border and print that size range all the way through your data. That way the whole will be printed and each printed page will have the border you want. You have to figure out what that single-page range is because it differs for font, margins, and printer driver. HTH Otto "VinceW" wrote in message ... I have code that sets the border around the printed area prior to printing. I works fine on a single sheet, but if the print area is over several sheets, the bottom of the border prints on the last page. Is there a way to set the border on each page? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show date printed, updated only when worksheet printed? | Excel Discussion (Misc queries) | |||
Last row printed formatting | Excel Programming | |||
No chart printed | Excel Worksheet Functions | |||
Everything You Need To Know About Printed Lanyards | Excel Discussion (Misc queries) | |||
Everything You Need To Know About Printed Lanyards | Excel Programming |