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 |
code for printing pages
- Insert Page Break
for each area you want on another page. - In the File Page Setup Sheet Print Titles Rows to repeat at top, but in 1-4 That's as far as I'm taking you. -- Hope this helps. Thanks in advance for your feedback. Gary Brown "Anthony" wrote: 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 |
All times are GMT +1. The time now is 01:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com