Generate unique number

**adeleex** · 10-18-2011, 06:05 AM

Hi all,

Is it possible to have a worksheet which has two buttons one of which generates a number between 1-100 and the other generates one from 101-200?

Many thanks,

Adele

**Macdave_19** · 10-18-2011, 06:11 AM

Hi Adele,

Have you used the Randbetween Function Before:

In seperate cells put the following

1-100

Please Login or Register  to view this content.

For the 101-200

Please Login or Register  to view this content.

Then just press F9 to randomly generate the numbers each time

Hope this helps

**Macdave_19** · 10-18-2011, 06:12 AM

by the way you'd best be a Leeds fan lol! MOT!

**adeleex** · 10-18-2011, 06:52 AM

Should have said the numbers must be sequential so same two aren't used twice and sorry don’t like football!

**ssu95bm** · 10-18-2011, 08:46 AM

Hi Adeleex,

I did something similar to this. I had a column in the spreadsheet containing all the previous values (in any order). You can then use this code in your macro:

Please Login or Register  to view this content.

Where X is the column containing all the previous values.

Does that help?

Kind regards,
ssu95bm

Generate unique number

LinkBack

Thread Tools

Rate This Thread

Display

Generate unique number

Re: Generate unique number

Re: Generate unique number

Re: Generate unique number

Re: Generate unique number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions