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

- 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