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