Select random cells from range and copy to sheet 2

H

Human_doing

Board Regular
Joined
Feb 16, 2011
Messages
137
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!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
simple range selection returning "run time error 91" randomly...
Replies
7
Views
188
rollis13
rollis13
D
  • Question
Random selection modification not working
Replies
2
Views
150
Damian37
D
F
  • Solved
Double click to copy a cell to the next empty cell in a different column and sheet (VBA code)
Replies
3
Views
261
kevin9999
K
F
  • Question
VBA to determine range of data at left side and copy it to the right side of Excel sheet.
Replies
4
Views
267
kevin9999
K
sharky12345
  • Solved
Copy x number of random rows from filtered range
Replies
4
Views
432
DanteAmor
DanteAmor

Forum statistics

Threads
1,214,649
Messages
6,120,728
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top