Data Validation with named ranges

[Stumbler]

Hello,

I have a wierd problem: in a planning module it should be possible to
choose the correct product in a validated list.
There is a matrix that shows only those articles that can be planned
on a specific machines.
Now when the possible values are mentioned in a fixed range
[Art_CA0003 refers to =ArtikelPerMach!$C$2:$C$40], it works fine.
However when I use a dynamic range
[Art_CA0001 refers to = =OFFSET(ArtikelPerMach!$A
$2;0;0;COUNTA(CA0001_);1)] it fails, allthough the range is shown as
it should under insert>name>define.
Hope my explanation makes sense.

If requested I can send out an example.

Thanks for your attention.

 

[Jim Rech]

I find that Data, Validation, List works fine with a dynamic range.
Something tells me you've introduced some complexity that perhaps didn't
make it into your message. If your example is not overly complex I'd be
happy to look at it.

Always helpful to mention your Excel version in any post.

--
Jim
| Hello,
|
| I have a wierd problem: in a planning module it should be possible to
| choose the correct product in a validated list.
| There is a matrix that shows only those articles that can be planned
| on a specific machines.
| Now when the possible values are mentioned in a fixed range
| [Art_CA0003 refers to =ArtikelPerMach!$C$2:$C$40], it works fine.
| However when I use a dynamic range
| [Art_CA0001 refers to = =OFFSET(ArtikelPerMach!$A
| $2;0;0;COUNTA(CA0001_);1)] it fails, allthough the range is shown as
| it should under insert>name>define.
| Hope my explanation makes sense.
|
| If requested I can send out an example.
|
| Thanks for your attention.

 

[Stumbler]

Jim,

Thanks for the offer,I will send it to you.
And you have a point about the extra complexity.

Regards,
Hans.