• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Named formula mystery

juanito

Member
I have a named formula for dynamic range "_dq" defined as follows:
=OFFSET(qualdata!$A$2;;;COUNTA(qualdata!$A:$A)-1;COUNTA(qualdata!$1:$1))

I am getting #NAME? errors referencing this formula from other worksheets.

If on the 'qualdata' source worksheet, I can type F5 go to, "_dq" and the range is selected. Yet if I type F5 go to, "_dq", from any other worksheet in my workbook, I get a "Reference is not Valid" error.

To add the the mystery, I have another named formula "_d" defined almost identically (the only difference is that it references a different worksheet), and this works perfectly throughout the workbook.

I will be very grateful if anybody can point to the possible source of this error. Thanks.

- juanito
 
Hi ,

I tried out your named range in a workbook , and I am not facing any problem.

Can you check 2 points ?

Whether calculation is in Automatic mode or Manual mode ?

Whether the scope of the named range is Workbook or any specific Worksheet ?

Narayan
 
Back
Top