Hi
Can some one help me
I need a code where i can write a number
maybe in a inputbox then the code shall see if the number i write already
are in the row, if Not write the number in the activecell , and if the are
there
error by msgbox or something like that

Hope some one can help

You don't need a macro. You can use validation... Try this. Highlite column A
(A1 should be the active cell). Select Data|Format ->Custom and add this
formula

=COUNTIF(A:A, A1) =1

Now try adding values into column A. It should not allow duplicates...
--
HTH...

Jim Thomlinson


"alvin Kuiper" wrote:

> Hi
> Can some one help me
> I need a code where i can write a number
> maybe in a inputbox then the code shall see if the number i write already
> are in the row, if Not write the number in the activecell , and if the are
> there
> error by msgbox or something like that
>
> Hope some one can help
>
>

Thanks

Alvin


"Jim Thomlinson" skrev:

> You don't need a macro. You can use validation... Try this. Highlite column A
> (A1 should be the active cell). Select Data|Format ->Custom and add this
> formula
>
> =COUNTIF(A:A, A1) =1
>
> Now try adding values into column A. It should not allow duplicates...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "alvin Kuiper" wrote:
>
> > Hi
> > Can some one help me
> > I need a code where i can write a number
> > maybe in a inputbox then the code shall see if the number i write already
> > are in the row, if Not write the number in the activecell , and if the are
> > there
> > error by msgbox or something like that
> >
> > Hope some one can help
> >
> >