I need to be able to print Excel data so that it looks like it was printed on
"pleading paper" (this term will be well-known to legal-types. It mostly
involves having an incrementing line number appear at the left edge of the
paper, on every other line. There also has to be a double line at the right
edge of the line-number cells, but I know how to accomplish that part!) The
line numbers need to restart with every new page, and this is where I am
running into problems.

For each worksheet in a book, I want the first 9 rows to repeat at the top
of each page. I figured out how to do that (File/Page Setup/Sheet...), and I
also repeated the first (leftmost) column on every page. I manually formatted
the first 9 rows with "pleading paper" number information as well. Hoping to
use that as a starting point, I tried to use a formula like this in the first
column of the remaining (data) rows:

=IF(CELL("contents",A9)="","",A9+1)

.... attempting to use the pattern set up by the first nine rows to number
the rest of each page. This worked fine for the first page, but it just kept
on incrementing the numbers on each successive page. Obviously, the process
of inserting the "9 rows" takes place at print time, and so this formula
fails. I tried variations on the theme of the formula above before realizing
this.

I figure I'm not the first person in the world to need to do this; but all
my searches so far have been fruitless. Of course, MS Word has a Pleading
Wizard that automates this whole process; and I suppose I COULD import all
the Excel data into Word, and let Word format it into Pleading form. However,
I need to also submit the data in Excel to show other calculations, and it
would just be much more convenient to just keep everything in Excel. I would
be willing to consider accomplishing this using a template or macro, as well
as a formulaic solution.

Thanks,
GB