code for printing pages

[Anthony]

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

 

[Gary Brown]

- 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.