When I go through my code I am using .HPageBreaks.Add Befo=Cells(x,y) to
add a page break at a certain cell. But I actually want to add two page
breaks so that I have a blank page inbetween can this be done? Or do I need
to insert a blank line first and then another pagebreak.

blank line with another pagebreak.

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
When I go through my code I am using .HPageBreaks.Add Befo=Cells(x,y)
to
add a page break at a certain cell. But I actually want to add two page
breaks so that I have a blank page inbetween can this be done? Or do I
need
to insert a blank line first and then another pagebreak.

THANKS, I was afraid of that. That also means that if I don't want to waste
the paper I need to change the border colour and visable lines.How would I
set the Row to not have any printable properties? Actually I have the first
two rows of the sheet repeating as a header row is it possible to print jsut
a blank sheet? Otherwise I'll waste 200+ sheets every time this thing runs.


"Tom Ogilvy" wrote in message
...
blank line with another pagebreak.

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
When I go through my code I am using .HPageBreaks.Add Befo=Cells(x,y)
to
add a page break at a certain cell. But I actually want to add two page
breaks so that I have a blank page inbetween can this be done? Or do I
need
to insert a blank line first and then another pagebreak.