Hi all,
I want to create a VBA program that will find a number preceded by an existing last number.
Example:
A001
A002
A003
A005
A007
The program should read the running number and suggest A004, and if you still run the vba program it will suggest the next number preceded by an existing last number to A006, and again to A008....
PLEASE ADVICE, THANKS!
I want to create a VBA program that will find a number preceded by an existing last number.
Example:
A001
A002
A003
A005
A007
The program should read the running number and suggest A004, and if you still run the vba program it will suggest the next number preceded by an existing last number to A006, and again to A008....
PLEASE ADVICE, THANKS!