Edit: I have no idea why it double posted this!
Ive been using the Macro that Norie helped me with flawlessly for over 2 years. Now I'm stuck...
The numbers have now reached over 100,000 and one of the leading zeros needs to be replaced.
My sequence will be 23PAL0094000 through 23PAL0101999
As with my previous posts the alpha numeric sequence is "23PAL00" followed by a sequential number however when I get to 100,000 it would need to change to "23PAL0" followed by the number.
It will need to look like this at the change to 100,000:
23PAL0099998
23PAL0099998
23PAL0099999
23PAL0099999
23PAL0100000
23PAL0100000
23PAL0100001
23PAL0100001
Here's the macro Norie wrote:
I certainly don't have the knowledge to modify this code as I've been trying unsuccessfully for an hour or so now.
Can someone help me please?
Bookmarks