Suppress all PageBreaks of a worksheet

[MichDenis]

Hi everyone,

If I want to suppress all "PageBreak" of a worksheet,
which method represent the best solution ?

Worksheets("sheet1").Cells.PageBreak = xlPageBreakNone
Or
Worksheets("sheet1").ResetAllPageBreaks

Are there a significant differences between this two approaches?
If yes, what are they ?

Thanks in advance for your collaboration and your time.

 

[Joe Farruggio]

Hi everyone,

If I want to suppress all "PageBreak" of a worksheet,
which method represent the best solution ?

Worksheets("sheet1").Cells.PageBreak = xlPageBreakNone
Or
Worksheets("sheet1").ResetAllPageBreaks

Are there a significant differences between this two approaches?
If yes, what are they ?

Thanks in advance for your collaboration and your time.

Joe Farruggio wrote:
I have seen no significant difference

 

[Guest]

If you want to suppress them, I would go with = xlPageBreakNone.

 

[Tom Ogilvy]

What do you want to achieve?

Maybe ActiveSheet.Displaypagebreaks = False

which will speed up your code, is what you want. The other two methods
don't remove automatic pagebreaks and may make them visible. (nothing
does).

 

[MichDenis]

"MichDenis" <[email protected]> a écrit dans le message de %[email protected]...
Hi everyone,

If I want to suppress all "PageBreak" of a worksheet,
which method represent the best solution ?

Worksheets("sheet1").Cells.PageBreak = xlPageBreakNone
Or
Worksheets("sheet1").ResetAllPageBreaks

Are there a significant differences between this two approaches?
If yes, what are they ?

Thanks in advance for your collaboration and your time.