[reposting]

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 with the generated
values.