View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michdenis michdenis is offline
external usenet poster
 
Posts: 135
Default Suppress all PageBreaks of a worksheet

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.