Pagebreak property

  • Thread starter Thread starter Nitin Pai
  • Start date Start date
N

Nitin Pai

Here is my problem. I am not able to set a manual pagebreak property in
excel using VB.
I have Excel 2003 and VB 6.0 with 11.0 excel object library. I have reduced
the columnwidth to 2.5
I have set the page setup to Landscape I am using the command

Worksheets(1).Columns("AZ").Pagebreak = xlPagebreakmanual

but it doesnt allow me to set the pagebreak there. It sets one pagebreak at
AJ and the other one at AZ which I dont want.
 
Here is my problem. I am not able to set a manual pagebreak property in
excel using VB.
I have Excel 2003 and VB 6.0 with 11.0 excel object library. I have reduced
the columnwidth to 2.5
I have set the page setup to Landscape I am using the command

Worksheets(1).Columns("AZ").Pagebreak = xlPagebreakmanual

but it doesnt allow me to set the pagebreak there. It sets one pagebreak at
AJ and the other one at AZ which I dont want.
Click to expand...

ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell // or
your cell location
 
Back
Top