VBA - finding last number

J

junddios

Joined
Sep 8, 2010
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine data in fields within one table 4
Help in Excel VBA for simple task 2
In visual basic 5
Sum based off of text -need help 2
Alphanumeric Auto Number like @### 1
VB 2
VBA how to find the Cell needed 2
Batch rename files in different directories? 7

Back
Top