| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pagebreak property
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pagebreak property
On Mar 30, 1:14 pm, "Nitin Pai" wrote:
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. ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=ActiveCell // or your cell location |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant move pagebreak in PageBreak View in Excel2003 | Excel Worksheet Functions | |||
| Runtime error 380 - Could not set the list property. Invalid property value. | Excel Programming | |||
| PageBreak in VBA??? | Excel Programming | |||
| Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Linear Mode
