Double Pagebreak?

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

When I go through my code I am using .HPageBreaks.Add Before:=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top