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

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