Robert
Maybe you can give us a little more info. How is your data laid out?
How many blank rows between rows of data? How long are the rows relative to
one printout row? Is all this on one sheet? How, exactly, are you telling
Excel to print the range? Exactly how? What does Excel do? What did you
want Excel to do?
HTH Otto