Request my Bingo Cards workbook and sneak a look at the code.
VBE project password is provided with the workbook.
I use a two array technique that Tom Ogilvy posted quite a while back.
Info at my website...
http://www.realezsites.com/bus/primitivesoftware
(at the bottom of the products page)
--
Jim Cone
San Francisco, USA
(Excel Add-ins / Excel Programming)
"SeanW."
wrote in message ...
I am using excel to make bingo cards. I am using the =randbetween(*,*)
formula to generate the numbers but I keep getting duplicate numbers. How can
I ensure that each cell will have a unique number?