Hi,

Thank you, but I've tried applying this to my form, but it doesn't really
work because I need it to change reference numbers after I print out 2 copies
of the form. Is there any other way to do this? Any other macro?

Thanks for the help.

john wrote:
have a look at this site:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
Hi!

[quoted text clipped - 21 lines]

Thank you!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200908/1