page numbering problems

I have created a form in Excel to use in court
documents. The number of printed pages varies, depending
on how much information is entered into the form. I need
to enter the page numbers at the top of each page from #
2 to the end of the document, but page 1 cannot have a
page # on it. I realize that I can do that in a header,
but because a header will also affect page 1 that doesn't
work for this form. What I have in mind is code to count
the printed pages - from that I can work backwards to
insert the specific page number after each page break;
however, everything I have tried so far either gives me
an error message or a null value. Any help would be very
much appreciated.

Check out:

http://www.mcgimpsey.com/excel/subs/...html#automatic


In article ,
"Wayne Cusack" wrote:

I have created a form in Excel to use in court
documents. The number of printed pages varies, depending
on how much information is entered into the form. I need
to enter the page numbers at the top of each page from #
2 to the end of the document, but page 1 cannot have a
page # on it. I realize that I can do that in a header,
but because a header will also affect page 1 that doesn't
work for this form. What I have in mind is code to count
the printed pages - from that I can work backwards to
insert the specific page number after each page break;
however, everything I have tried so far either gives me
an error message or a null value. Any help would be very
much appreciated.