hellow
I need to create VBA code to create a random code automatic (based on default -> TES001 ... TES145 and ARQ001 ... ARQ145 etc.).


I have a tab "Tb_Rnd" which would crado codes via VBA.


But I need not repeat codes.
Aupha-Random-Automatic-Used
TES001
ARQ001