I created a validaton, it should be in column b only upto the last row of
data in col a, and the amount of rows with data in col a will change all the
time, what should I do? Do I have to delete and recreate the location every
time, if so then how? thanks in advance!

Use a formula of

=OFFSET($A$1,,,COUNTA($A:$A),1)

in the list formula of the DV.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mikeb" <(E-Mail Removed)> wrote in message
news:AECD68DA-7165-4632-B9B5-(E-Mail Removed)...
> I created a validaton, it should be in column b only upto the last row of
> data in col a, and the amount of rows with data in col a will change all
the
> time, what should I do? Do I have to delete and recreate the location
every
> time, if so then how? thanks in advance!
>

Bob, what I'm trying to do is have validation list in column B consisting of
all the unique values in column A and if col A goes to row 100 col B goes to
Row 100, the number of rows in col a changes. In my code I get the unique
values and place them in another sheet, I now want to create a dynamic named
range and use that for validation in col B.

"Bob Phillips" wrote:

> Use a formula of
>
> =OFFSET($A$1,,,COUNTA($A:$A),1)
>
> in the list formula of the DV.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "mikeb" <(E-Mail Removed)> wrote in message
> news:AECD68DA-7165-4632-B9B5-(E-Mail Removed)...
> > I created a validaton, it should be in column b only upto the last row of
> > data in col a, and the amount of rows with data in col a will change all
> the
> > time, what should I do? Do I have to delete and recreate the location
> every
> > time, if so then how? thanks in advance!
> >
>
>
>

Just use the formula that I provided to create the named range then.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mikeb" <(E-Mail Removed)> wrote in message
news:5455E413-A835-4FE5-A914-(E-Mail Removed)...
> Bob, what I'm trying to do is have validation list in column B consisting
of
> all the unique values in column A and if col A goes to row 100 col B goes
to
> Row 100, the number of rows in col a changes. In my code I get the unique
> values and place them in another sheet, I now want to create a dynamic
named
> range and use that for validation in col B.
>
> "Bob Phillips" wrote:
>
> > Use a formula of
> >
> > =OFFSET($A$1,,,COUNTA($A:$A),1)
> >
> > in the list formula of the DV.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "mikeb" <(E-Mail Removed)> wrote in message
> > news:AECD68DA-7165-4632-B9B5-(E-Mail Removed)...
> > > I created a validaton, it should be in column b only upto the last row
of
> > > data in col a, and the amount of rows with data in col a will change
all
> > the
> > > time, what should I do? Do I have to delete and recreate the location
> > every
> > > time, if so then how? thanks in advance!
> > >
> >
> >
> >