Using VBA is very interesting, i really would love to learn alot about that.
Enjoyed working through the steps in the example from the page you mentioned.
I sure would recommend anyone who loves to learn more to try it. I
personally enjoyed it. Guez there are many ways to skin a cat. Cheers!

"RayT" wrote:

Thanks, for takin the time. I will try that? Cheers!

"Chip Pearson" wrote:

I don't believe there is anyway to do this with a formula; you'll need some
VBA code. See http://www.cpearson.com/Excel/randomNumbers.aspx for quite a
few choices. Look at the section entitled "Getting An Array Of Unique,
Non-Duplicated Value" and the UniqueRandomLongs function.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"RayT" wrote in message
...
Could you kindly assist me with a formula that generate 6 numbers between
1
and 49, without repeating any of the integers.
Thanks!