Code that will add 1 alphanumeric value in cell

[randall78]

Hi,

I have some code that finds the next empty cell in a column and inputs the value of the above cell + 1.

The code works for just numeric values, but i would like to do this with alphanumeric values (ENG00001 + 1)

This is to generate a sequential job number, ENG00001, ENG00002, ENG00003 and so on.

I should point out that the data is in a table and this should only happen when the user clicks a command button.

What do change the below code to.

Please Login or Register  to view this content.

[KOKOSEK]

Please Login or Register  to view this content.

[randall78]

Thank you very much.