I am new here, so I don't know how to ask this, I have a project of printing stickers the problem I have is changing the numbering
how to I create a macro that can change numbers as needed
From 0001ART02 TO 999JKL10
without repeating any numbers
It seems you are a describing a range with codes you provided.
I'd create a formula in Excel. And then use a exported CSV in a coreldraw merge later.
Not seeing your pattern exactly for when the letters would change sequentially.
You can find and download my free macro Numeranger. Here is an example (gif-file) how to make numbering for stickers.
the letters are supposed to change after every 500 numbers sequence