Hi there,

I need your help in designing a custom Macro/Function to automatically generate a series of random number and a separate function to generate a random series of letters.

The syntax would be as follows:

Rand_Num(1,1000) - this function would generate a random series of numbers from 1 to 9999 eg. 6518

Next. I need a separate function to generate a random series of letters. The syntax would be as follows: Rand_Ltr(4,A-Z)

So this function would return four letters that are randomized from A-Z eg. KTMR

Any help with this is greatly appreciated.

Thanks in advance,

Cheers,

Jason