Forum Discussion
Unassigned number limit
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...
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