Page Break based on Dates
 

Beginning in column A, cell A2 I have a list of dates. I
would like the list to page break so that I have dates for
Mon to Sat on each page and the next page would start the
with the following week and so on. I have all my PageSetup
properties working fine I just do not know where/how to
begin coding the PageBreaks. It is possible to 1 weeks of
data to take up/carry over on to other pages. Thanks, Dan

Column A
Row 2 3/8/05
3/9/05
3/10/05
3/11/05
3/12/05
3/14/05 new page/week

Page Break based on Dates
 

Hi Dan

Maybe ?
http://www.rondebruin.nl/print.htm#Breaks

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dan" wrote in message ...
Beginning in column A, cell A2 I have a list of dates. I
would like the list to page break so that I have dates for
Mon to Sat on each page and the next page would start the
with the following week and so on. I have all my PageSetup
properties working fine I just do not know where/how to
begin coding the PageBreaks. It is possible to 1 weeks of
data to take up/carry over on to other pages. Thanks, Dan

Column A
Row 2 3/8/05
3/9/05
3/10/05
3/11/05
3/12/05
3/14/05 new page/week