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.

MichDenis wrote:
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

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

"MichDenis" wrote:

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.

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).

--
Regards,
Tom Ogilvy

"MichDenis" wrote in message
...
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.

"MichDenis" a écrit dans le message de news:
...
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.