On Oct 18, 12:20 pm, Paul B. wrote:
I would like to generate a row of 5000 - unique random numbers
and not have them change once generated.

Irritating, isn't it?

One way: Create a UDF that calls the VBA function Rnd().

Another way: After generating the column using =RAND(), copy the
column, then use Paste Special -- Values to replace the column.