Cell Data Validation with dynamic Range

Can I use the following code:

With ActiveCell
.Validation.Delete
.Validation.Add xlValidateList, , , "=" & "ListRange"
End With

with several cells in a column BUT using for each SPECIFIC cell a
SPECIFIC ListRangexx

Example:

Cell "A1" Value: 85 this cell will use Data Validation ListRange85
which is a range to use with value 85
Cell "A2" Value: 86 this cell will use datavalidation ListRange86 which
is a range to use with value 86

These ranges(ListRange85" , ListRange86 ) are dynamic They will be
Created from an Imported Table to this workbook

Here is the Layout of that table:

Item/Price
1185/$.5
2285/$.6
3386/$.7
4486/$.8
5586/$.9

The ListRange85 will contain two Validations 1185 and 2285
The ListRange86 will contain three Validations 3386 ,4486 and 5586

So When I select cell A1 I get to choose between 1185 and 2285

I hope I made myself clear enough



The ListRange85 is dynamically filled each time I open a wb from a
onother table imported to this workbook

Hi Arishy,

I am not clear about your intention.

However, see Debra Dalgleish's Dependent List page at:

http://www.contextures.com/xlDataVal02.html


See also, xlDynamic's Dependent Dropdowns page at:

http://www.xldynamic.com/source/xld.Dropdowns.html


---
Regards,
Norman



"Arishy" <[email protected]> wrote in message
news:[email protected]...
> Can I use the following code:
>
> With ActiveCell
> .Validation.Delete
> .Validation.Add xlValidateList, , , "=" & "ListRange"
> End With
>
> with several cells in a column BUT using for each SPECIFIC cell a
> SPECIFIC ListRangexx
>
> Example:
>
> Cell "A1" Value: 85 this cell will use Data Validation ListRange85
> which is a range to use with value 85
> Cell "A2" Value: 86 this cell will use datavalidation ListRange86 which
> is a range to use with value 86
>
> These ranges(ListRange85" , ListRange86 ) are dynamic They will be
> Created from an Imported Table to this workbook
>
> Here is the Layout of that table:
>
> Item/Price
> 1185/$.5
> 2285/$.6
> 3386/$.7
> 4486/$.8
> 5586/$.9
>
> The ListRange85 will contain two Validations 1185 and 2285
> The ListRange86 will contain three Validations 3386 ,4486 and 5586
>
> So When I select cell A1 I get to choose between 1185 and 2285
>
> I hope I made myself clear enough
>
>
>
> The ListRange85 is dynamically filled each time I open a wb from a
> onother table imported to this workbook
>