Clear or Remove Page Breaks in Excel

Question

Hi all,

I'm trying to figure out how to remove page breaks from my excel sheet through vb.net. I have a print area setup and it has  vert and a hort page breaks in it and I cant remove them I've tried the following from other threads I've read. I pretty much got all the other stuff on my own now I'm looking for direction so I can correct it its the only thing holding me back now from finishing my project in vb.net and ya I'm still a beginner but I'm learning alot.

Hope I'm in the right spot for this if not please direct me to the right spot...sry

thx in advance,

mrggutz

xlWorkSheet_Picture.Cells.PageBreak = Excel.XlPageBreak.xlPageBreakNone







xlWorkSheet_Picture.HPageBreaks.RemoveAt(0) "

xlWorkSheet_Picture.PageSetup.PrintArea = "A1:M38"

Answer 1

Wow that many views, a move and no replys. Someone must have alittle knowledge about this.

Answer 2

Hello,

Something like the following may resolve it:

 

ExcelApp.ActiveSheet.ResetAllPageBreaks()

 

---

Kind regards, Dennis (http://xldennis.wordpress.com/)

Answer 3

I think it should be as simple as this:

ActiveSheet.ResetAllPageBreaks

 

Answer 4

ryguy72,

The OP use VB.NET and therefore my code works and not Yours.

Dennis
Microsoft Excel MVP

 

 

---

Kind regards, Dennis (http://xldennis.wordpress.com/)