Indirect and Dynamic Range Names

C

condotta

Hello,

I have a dynamic range name, "HotDogDay", set up on one sheet using
=offset(SheetName!Range,0,0,Counta(....). When viewing this name
through "Insert" --> "Name" --> "Define", the range checks out fine. On
another sheet I have some data validation using
=Indirect(Substitute(A1," ","")) , where A1 has the name "Hot Dog Day"
(note spaces). Opon entering the indirect function in the data
validation source box, Excel informes me "The source evaluates to an
error. Would you like to continue?". Alternatively, if in the data
validation I directly enter =HotDogDay in the source box the data
validation works fine. Can anyone explain why my
=Indirect(Substitute(A1," " ,"")) does not work for me with a dynamic
range?

Regards,

Stefano
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Depedent Dropdown and INDIRECT($P$8) with a twist 4
Why doesn't indirect work with a dynamic range created using offse 2
Indirect and Dynamic Range 16
data validation with indirect ref to dynamic range 4
Multiple Dynamic Named Ranges across Columns 3
Data Validation with dynamic ranges 2
INDIRECT with dynamic range 9
Offset Named range in Datavalidation List 3

Top