I have a number of dynamic named ranges which I have created using the ofest function eg =OFFSET($B$6,0,0,COUNTA($B$6:$B$106),1)
I'd like to be able to make an indirect function within data validation to that range (the name of the range is in B5)
When I try and do this it wont allow me to but it will if i 'fix' the range so that its is B6:B106
Any ideas?
Can you post your sheet?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry - My organisation doesnt allow this and Im working through one of their laptops
What's the name of the range you're using
just 'Months'
Ive spoken to the lovely people in IT - Here is the file
I guess I'm having a stoopid day... Exactly what are you trying to achieve?
Here is a file with examples of various kinds of dynamic Data Validation lists. Two of them use the OFFSET function and one uses a table.
Hope this helps.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks newdoverman
Glen. What I'm trying to do is use the named range 'Month' (and others, all of which are dynamic) as part of a formula in another worksheet so from a list a specific entry by the user they will get a validation list relevant to their entry. Hope that makes sense
What is the formula that you are trying too write using the names?
One thing that you can try is to write the formula using actual cell references (like a normal formula) then substitute the correct names in the formula for the cell ranges concerned.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks