Re: with random No's calc how can I stop two different columns pre

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Tushar provided a great link:

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

--
Regards,
Tom Ogilvy

"Excel Problems" <ExcelProblems@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4FC2613C-07C4-4AC9-BF33-20E9FAF2F402@xxxxxxxxxxxxxxxx
> Tom,
> Many thyanks but you sugest writting my own routine, can you provide
example
> of a routine please
>
> thanking you in anticipation regards
>
> Bernie
>
> "Tom Ogilvy" wrote:
>
> > Randbetween does not generate unique random numbers. Just random
numbers.
> >
> > the solution would be to write you own routine to generate unique random
> > numbers or query Google for posts in this group where such code has been
> > produced many times.
> >
> > http://groups-beta.google.com/advanced_search
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Excel Problems" <Excel Problems@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
> > news:53C37215-16C0-4068-AB0E-15F2A59F5329@xxxxxxxxxxxxxxxx
> > > I have used the Randbetween calculation in four columns, however on a
few
> > > occasions the same number is predicted in two different columns, how
can I
> > > overcome this problem
> >
> >
> >


.



Relevant Pages

  • Re: check if file already is open
    ... Regards, ... "Tom Ogilvy" wrote: ... Macro Code to Check Whether a File Is Already Open ... >> interrupt the routine and give a msg "the file is already opened by ...
    (microsoft.public.excel.programming)
  • Re: with random Nos calc how can I stop two different columns pre
    ... Many thyanks but you sugest writting my own routine, ... thanking you in anticipation regards ... "Tom Ogilvy" wrote: ... > Randbetween does not generate unique random numbers. ...
    (microsoft.public.excel.programming)
  • Re: Advanced Filter Criteria Problem
    ... "Tom Ogilvy" wrote: ... > rather than just ABC ... >> I having a little problem with the output from a routine using the ...
    (microsoft.public.excel.programming)
  • Re: Excel VBA Write to xls ?
    ... I would like to open multiple xls files, manipulate them, and then save them ... I have a routine that I need to do on hundreds of files..and ... "Tom Ogilvy" wrote: ... >> Regards, ...
    (microsoft.public.excel.programming)
  • Re: starting another program
    ... If you aren't using Windows 9x or Millenium, ... Regards, ... > Dim intFile As Integer ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)