Each row to contain a unique ID (via VBA)

[Tywardreath_NZ]

Hi

I am a VBA novice. So apologies in advance if the question is an easy one.

I have some code (see below) which gives me a unique id in column A for each row. The format is yymm-0. Currently the numbering portion does not reset, it just carries on consecutively. I would like it to restart when the month changes.

So for May I would like the numbering to go 0905-1, 0905-2... until June, when it would reset and go as follows 0906-1, 0906-2.

Is anyone able to help?

Please Login or Register  to view this content.

[rylo]

Hi

Try this

Please Login or Register  to view this content.

rylo