Excel Create a Macro with button to generate the next sequential number in an Alphanumeric string
I looking for some assistance in creating a macro that when a button is clicked, the macro sequentially increases an alphanumeric string, example of the string is as follows and the number should increase by 1 after the macro is run. CA-123456 When macro is run, next alphanumeric will be CA-123457 Thanks!
This question generated 10 answers. To proceed to the answers, click here.