Programmatically removing pagebreaks

R

Rob

Does anyone know how to programmatically remove all pagebreaks in a sheet?

I am using Excel X for the Mac

Rob
 
J

JE McGimpsey

Rob said:
Does anyone know how to programmatically remove all pagebreaks in a sheet?

I am using Excel X for the Mac
Click to expand...

one way:

ActiveSheet.ResetAllPageBreaks
 

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

Similar Threads

Conditional Pagebreaks in Mailmerge 2
HPageBreak not working 4
How to determine Last row of a Page in Excel 7
Detail_Format works in Print Preview but Not When Printing 0
Pagebreak 4
Hyperlinking automatic?? 1
You'll need a new app to open this about link 1
print area changes 2

Top