| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
| PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Hybrid Mode
