Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was wondering - how can one programatically set
where the page breaks will occur. Is it doable at all? Turn on the macro recorder and insert a pagebreak manually. Turn off the macro recorder. then look at the recorded code. That should get you started. Just be aware that if the page will only hold 66 rows (as an example), placing a pagebreak at row 70 (again as an example) will not keep it from pagebreaking at row 66. If this sounds obvious, it doesn't seem to be for many. Thanks. -- Vänligen Konrad --------------------------------------------------- Sleep - thing used by ineffective people as a substitute for coffee Ambition - a poor excuse for not having enough sence to be lazy --------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
prevent page printout | Excel Programming | |||
suppressing a footer only on the first page of a printout | Excel Discussion (Misc queries) | |||
suppressing a footer on the first page of a printout | Excel Discussion (Misc queries) | |||
suppressing a footer on the first page of a printout | Excel Programming | |||
ActiveSheet.Printout or Page Setup? | Excel Programming |