Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code for printing pages
Hi all,
On my worksheet range A1:K4 are used as my sheet 'headers' rows 4:70 are then used to place data I want to change the simple code I have that prints all the data. I want the headers in range A1:K4 to be shown at the top of each page printed. for example Page 1 will print the headers on range A1:K4 then all the data on rows 5:19 Page 2 will print the headers on range A1:K4 then all the data on rows 20:35 Page 3 will print the headers on range A1:K4 then all the data on rows 36:51 etc etc Obviously I only want the above 'pages' to be printed if there is data on them is this possible?? thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Printing 3 out of 4 pages | Excel Discussion (Misc queries) | |||
Printing more pages than necessary | Excel Programming | |||
Printing more pages than necessary | Excel Programming |