Unassigned number limit

[thomas cascia]

Can I assign a different number to a sheet every time I print? Or do I have to number every time. I would like to start with #100. 

Thank You...

[#2]

Hi Thomas

You could do it with a lttle VBA if you know the basics of that.

I'd set up a named cell called PageNumber, then add a short VBA code

Sub PrintMe()

    Sheet1.PrintOut Copies:=1

    Range("PageNumber").Value = Range("PageNumber").Value + 1

End Sub