Vertical Page Break How To Change Help

R

RompStar

Ok, by default I would like to have Columns A:I fit on a single
Vertical Page Break.

When I go to ViewPageBreaks, and I reset Pagebreaks, there is a Page
Break running
down on column H, to the left of it and there is a Vpagebreak running
down column I, to
the Right of it, those are the defaults.

The I Page break is good, as my columns would run from Range("A:I"),
so how
to delete the page break in column H ?

I tried this...

With ActiveWorkbook.Sheets(sheetName)

.VPageBreaks.Add Before:=.Range("J1") ' to add page break to column
J
.Columns("H").PageBreak = xlNone ' to delete page break on column H
(not working)

End With

Can anyone lend me a hand ?

THanks!
 

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

Top