Have unique "keys" in the format of 1-111 in Excel. Want to be able to generate thru VBA the next sequential key.
Can't just add one to 1-111 because 1-111 is a string. Need to be able to get from 1-999 to 2-000 also.
Any suggestions on how to handle this most efficiently?
Andrea
Can't just add one to 1-111 because 1-111 is a string. Need to be able to get from 1-999 to 2-000 also.
Any suggestions on how to handle this most efficiently?
Andrea