It's really difficult for beginners to understand VBA arrays, and they don't know what it is for. Learning VBA arrays can refer to some examples for in-depth study, or find some problems about VBA arrays and then try to solve them. Practice makes perfect, so that the array will not be unfamiliar.
Attached "Using Array Array Array to Generate Non-repetitive Random Numbers"