Data Validation with named ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stumbler - 02 Apr 2008 10:40 GMT

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.

Reply to this Message

Jim Rech - 02 Apr 2008 13:30 GMT

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.

Signature

Jim

| Hello,
|
[quoted text clipped - 13 lines]
|
| Thanks for your attention.

Reply to this Message

Stumbler - 03 Apr 2008 06:29 GMT

Jim,

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

Regards,
Hans.

> I find that Data, Validation, List works fine with a dynamic range.
> Something tells me you've introduced some complexity that perhaps didn't
[quoted text clipped - 21 lines]
> |
> | Thanks for your attention.

Reply to this Message

Rate this thread: