I need a way of getting excel to produce a sequential number. This would be easy enough if it weren't for each number needing to be in a new worksheet, with new worksheets being automatically produced via a macro. It seems to me that I need a way of the last used number being stored somewhere so that Excel and reference this and add 1...
I realise this may seem ambiguous, but if anyone could help it would be amazing thanks
Yo can store the number in the Registry, a text File or a named range. All require VBA, it really depends why you need this.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks