Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pagebreaks are not made
Hi,
I have a problem to establish horizontal pagebreaks for my worksheet. The PrintArea is set from cell A1 to cell M300. I hide rows if they may not be seen. this is the code I use: sLijst.HPageBreaks.Add Befo=sLijst.Cells(vRow, 1) where sLijst is the reference to the worksheet and vRow is the row (integer < 300) before which the pagebreak must be established. I make the breaks in a loop where vRow is added by 40 each time. No breaks are made. Thanks for your help Jos Vens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I apply the same formating and pagebreaks to another workbook | Setting up and Configuration of Excel | |||
Is there no one who uses PageBreaks? HPageBreaks? | Excel Worksheet Functions | |||
pagebreaks | Excel Programming | |||
VBA Code Printouts with PageBreaks | Excel Programming | |||
Excel pagebreaks | Excel Programming |