Data Validation Error!

S

Soniya

Hi All,

I use the following formula under Insert>Nmae>Define
to name a range as "MemberList"

=OFFSET(Membership!$A$1,1,0,COUNTA(Membership!A:A)-1)

Then When i use in another sheet as a Cell Validation
Cutom formula =INDIRECT("Membership!Memberlist") it says
an error in location

At the same time if I use VBA to define "Memberlist" in
my Membership sheet (dynamic Range)and use the Formula in
Data Validation it works Fine

what would be the possible reason for the failure in the
first Case?

is it possible to define a name using my OFFSET Formula
and use the name in Datavalidation so that I can Avoid
running that part of code?

TIA
Soniya
 

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

Autofill a dynamic range with a formula. 1
Multiple Dynamic Named Ranges across Columns 3
Trouble with dynamic named range 4
InputBox to name a range 2
Dynamic Autofill Error 1
Why the DataValidation Code not working? 0
How I can set dynamic pivot table ONLY when I have enough data point 1
best way to validate data in forms; 2010 1

Top