Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation with indirect ref to dynamic range
Am I correct in thinking that I can't do a data validation list, where I use
Indirect to refer to a cell that contains the name of a dynamic range in another sheet? Thanks in advance, Doug |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation with indirect ref to dynamic range
That appears to be the case. I suspect that using INDIRECT causes Excel to
return an Array Constant, which is not valid as a DV source. Whereas, directly referencing the Dynamic Range Name returns the actual list. Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Doug Glancy" wrote in message ... Am I correct in thinking that I can't do a data validation list, where I use Indirect to refer to a cell that contains the name of a dynamic range in another sheet? Thanks in advance, Doug |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation with indirect ref to dynamic range
Thanks Ron,
That's what I'm seeing. On further investigation it doesn't even seem to work outside of DV on the same sheet. In other words, if I try an Indirect reference to a dynamic range on the same sheet it doesn't works. Funny, I thought it did. Doug "Ron Coderre" wrote in message ... That appears to be the case. I suspect that using INDIRECT causes Excel to return an Array Constant, which is not valid as a DV source. Whereas, directly referencing the Dynamic Range Name returns the actual list. Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Doug Glancy" wrote in message ... Am I correct in thinking that I can't do a data validation list, where I use Indirect to refer to a cell that contains the name of a dynamic range in another sheet? Thanks in advance, Doug |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation with indirect ref to dynamic range
There are instructions and a sample file here for dependent validation
with a dynamic list: http://www.contextures.com/xlDataVal02.html#Dynamic Doug Glancy wrote: Am I correct in thinking that I can't do a data validation list, where I use Indirect to refer to a cell that contains the name of a dynamic range in another sheet? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation with indirect ref to dynamic range
Debra,
I should of course have checked your site. Brilliant! Doug "Debra Dalgleish" wrote in message ... There are instructions and a sample file here for dependent validation with a dynamic list: http://www.contextures.com/xlDataVal02.html#Dynamic Doug Glancy wrote: Am I correct in thinking that I can't do a data validation list, where I use Indirect to refer to a cell that contains the name of a dynamic range in another sheet? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic name range for use in data validation | Excel Worksheet Functions | |||
dynamic range and data validation | Excel Worksheet Functions | |||
Cell Data Validation with dynamic Range | Excel Programming | |||
Dynamic Range for Data Validation | Excel Programming | |||
Data Validation to check Dynamic range in another sheet | Excel Programming |