Remove Any Pagebreaks

[Gordon@work]

I'm using the this code to print some info out of an existing worksheet and I'd like to force excel to remove all pagebreaks, as the last column or two is always printed onto another page. Does anyone know how to programatically remove pagebreaks?

Please Login or Register  to view this content.

[dominicb]

Good morning Gordon@work

How about something like this :

Please Login or Register  to view this content.

HTH

DominicB

[Gordon@work]

That causes an error saying: Unable to set the pagebreak property for the range class
I tried another line which doesn't cause an error, I think because it's concerning the actual location of the break, but it just doesn't do anything at all: Columns("B:C").PageBreak = xlPageBreakNone

[Ikaabod]

If you just want it to print on one page maybe this would suffice:

Please Login or Register  to view this content.

[Gordon@work]

Thanks Ikaabod.
It doesn't generate an error, but still prints the last column on a separate page.
I've tried it from two other people's machines and we all have the same problem, this is infuriating.

[dominicb]

Hi Gordon@work

That causes an error saying: Unable to set the pagebreak property for the range class

That's strange. It works just fine for me.

Sticking with the one liners, try this :
Sub test()

Please Login or Register  to view this content.

(obviously, you replace "Sheet1 with your sheet name"

HTH

DominicB

[Gordon@work]

Hello dominicb,
That function simply removes user-created page breaks, so nothing happened when I ran that line.
These are Excel generated/automatic pagebreaks which are due to the width of these columns.

Thank you for the suggestion anyway.

-
Gordon

[shg]

Can you post an example that illustrates the problem?

[Gordon@work]

All forty or so tabs of about twenty workbooks are broken this way, and I need at least column E included on the same page. I just can't make it work.

[shg]

I meant a spreadsheet, not a picture ...

[Gordon@work]

Sure. I wouldn't have thought of that!

[shg]

OK, I don't see the problem. I set the print area to columns A:F, and did File > Page setup > Fit to: 1 page(s) wide by (blank) tall, and it printed fine.

[Gordon@work]

How strange. We have a new printer, maybe it has a dodgy driver or something then.
Would anyone mind telling me if they can programatically move/remove the pagebreak at all please?

Thank you all so much for your time.

- Gordon