Select random cells from range and copy to sheet 2

[Human_doing]

Hi all,

I have a workbook that has a list of numbers in column A. Can anyone please assist with the VBA to do the following:

1. Bring up a message box asking how many random cells should be selected.

2. Select the requested number of random cells.

3. Copy to column A on sheet 2.

It would be beneficial if a cell could only be selected once i.e. to avoid the random selection of duplicates,

Thanks in advance for any help!

 

[Jameo]

Any reason you cant just use excels random number generator?

 

[Human_doing]

I believe that that is an add-in? And unfortunately this will be for use behind a firewall that doesn't allow ANY downloading, including Microsoft add-ins. Also, the numbers in column A are six digit numbers so a randomly chosen number wouldn't actually help with this,

Thanks