Random Number Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ken ogden - 29 Jun 2004 23:41 GMT

Hi,

Does anybody have, or are smart enough to write, an excel macro that will
produce random numbers WITHOUT duplicates. I can't see to get my head around
this problem

Reply to this Message

Anders Silven - 30 Jun 2004 00:48 GMT

Also asked in .excel. Please don't multipost.

You may provide more details on what you wish the macro to produce and where.

Regards,
Anders Silven

> Hi,
>
> Does anybody have, or are smart enough to write, an excel macro that will
> produce random numbers WITHOUT duplicates. I can't see to get my head around
> this problem

Reply to this Message

Tushar Mehta - 30 Jun 2004 03:31 GMT

See http://www.tushar-
mehta.com/excel/newsgroups/rand_selection/index.html

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Hi,
>
> Does anybody have, or are smart enough to write, an excel macro that will
> produce random numbers WITHOUT duplicates. I can't see to get my head around
> this problem

Reply to this Message