Hi all, this has no doubt been asked many times...
I had an Excel invoice up and running with auto date and
invoice numbers. I accidentally saved over it so that the date and invoice number became static.
I have been
unable to get it to work again, been trying for ages! since Friday 13th when I messed it up!
I have cut and pasted
from:http://www.mcgimpsey.com/excel/udfs/sequentialnums.html where I originally got the code. but can't get it to work
I would need the invoice numbers to start 1001, otherwise I presume I'd have to open and close the file loads
of times to avoid duplicating previously used invoice numbers from when the thing was working?
Any help would be
Many many thanks in advance.
P.s was getting error 9 subscript out of range, got it
opening without error messages, but not counting up, then tried different codes from different places, now I'm totally
Edit: I have now put attached the correct file.