Repeat Rows At Top Function

[bigmerf]

I have a spreadsheet with about 10 pages of data. I want to print the 1st row on all of the pages but the last page.

I went to the File-->Page Setup-->Sheet Tab and then selected the row I wish to repeat at the top of each page.

Now the question I have is: Is it possible to repeat the row on every page EXCEPT for the last row? I tried some coding such as Range(1:1) - (page -1) or something to that effect. I can't seem to get it to work.

Does anyone know of a way to make this happen?

Any help would be great!

 

[sawedoff]

Put all the information from your last page on another worsheet. Then set up the rows on the worksheet that DOES have the repeated rows, and when you print, tell it to print entire workbook.



Sawedoff