View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Re-setting HPageBreak

I have an employee scheduling calendar that will dynamically adjust itself
according to the number of employees. How do I get the automatic HPageBreak
to adjust to the last row? For example the previous schedule ended on row
62. That is where the HPageBreak is. After adding some employees the last
row is now 72. Next time there may be fewer employees ending at row 65. How
do I force the HPageBreak to the last row, wherever it is. The VPageBreaks
have already been set and will never change, so I do not want to ReSetAll.

Mike F