printing automation
 

I have a spread sheet that varies in length based on imported data. I have
headers and footers I use on each page. I use columns A1..R1 and rows
A1..A63. I want to automate this so if my data is longer than A63 (one page
I have defined) I will get a second page or more as required to print. How
do I automate this so I get my data and no blank sheet to print?
--
wsk