Hi Adeleex,

I did something similar to this. I had a column in the spreadsheet containing all the previous values (in any order). You can then use this code in your macro:

NextNumberToUse = Application.WorksheetFunction.Max([X:X]) + 1

Where X is the column containing all the previous values.

Does that help?

Kind regards,
ssu95bm