I current use the below piece of code to generate a sequential reference number on a userform.
This works fine but what im trying to do is not have it done by counting the row as I already have some reference numbers in there.
The sheet that it transfers to starts at row 3 but the count starts on "002".
Is it possible to have it count directly on from the last reference without it being linked to the row its on?
Thanks in advance.