Hello,
I need a macro that will randomly pick 2 numbers from 1 to 8 each number must be different example 3&6, 4&5, 7&1, 8&3, 2&7 and so on.
I want to use this as a lucky dip to be able to press a button and have the 2 digits displayed on the sheet in cells A8 and B8.
I have tried doing this myself for several days now without any joy so I am asking for help please.
Thanks.
Last edited by harry h; 06-11-2014 at 03:29 AM. Reason: make clear
Please Login or Register to view this content.
Last edited by Hawkeye16; 06-11-2014 at 04:03 AM. Reason: Better Sub name
how about just a formula
(using a helper column)Please Login or Register to view this content.
Last edited by scottieh; 06-11-2014 at 04:06 AM.
scottieh - That second formula will create a circular reference error. Your random number did make me notice mine did not give equal weighting to the end points... This gives equal weighting...
Please Login or Register to view this content.
Last edited by Hawkeye16; 06-11-2014 at 04:21 AM.
woops i had it in columns B8 - D8...
actually this is probably not an exact result it would create some small amount of bias and to fix that I might need to use more cells... so probably best to just go with your macro...
Last edited by scottieh; 06-11-2014 at 04:29 AM.
We wants it, we needs it. Must have the precious.
Wow thanks guys,
You did it it took me days not to be able to do it, but I know why now.
Thank You all.
harry h.
(All will soon know his name as Jehovah the one and only true God)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks