- 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