Excel Page Break Problem

[Miguel]

Hi,

I am using excel through my vb.net application and the only thing I cannot
get right is to remove all page breaks from the worksheet.

I need to remove all the vertical page breaks, then horizontal page breaks
and then calculate and create them from
my application.

I need help

thanks

Miguel

 

[Anushi]

Hi Miguel,

If u are asking through code, then this is the wrong NG to post in.
However, manually you do it like this :
To remove all page breaks, select all the cells in the sheet (use the
keyboard shortcut Ctrl+A,
or click the Select All button at the corner of the sheet's headings). From
the Insert menu, select Reset All Page Breaks.
Save the workbook and reopen. All the page breaks are deleted.

HTH,
Anushi

 

[Dave Peterson]

I don't speak the .NET, but if I were doing it in VBA, I'd do something like:

Worksheets("sheet1").ResetAllPageBreaks

All I did was record a macro in excel when I did it manually--if it works, it
may be useful to remember when you're struggling with excel from your VB.Net
development.