Update "Insert Name"

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

Cell A1 contains the number of valid cells in a column (A).

I would like to use the value of Cell A1 to update the "Refers to" value found in...Insert,
Name, Define.

For example:
Refers to: =Names!$A3:$A10
I want to use the value in Cell a1 to replace the 10 in the above range.

Can someone explain how to do this?

Thanks,
Bernie
 
Thanks for your help, Frank.

When I add your formula to the "Refers to" box, it gets changed to the following, and my
"Name" (Hotels) is no longer visible, so of course the drop down box has no entries:

=INDIRECT("'Names'!$A$3:$A$" & Names!A1)

Got a suggestion on how to fix this?

By the way, the quote marks (single and double) are confusing to say the least...

Bernie
 
Hi
try chaning the name definition to
=INDIRECT("'Names'!$A$3:$A$" & Names!$A$1)

Also what value does A1 contain?
 
Frank,

It still doesn't work. I copied the formula into a blank cell (just to see what would happen)
and got a #REF error.

Cell A1 contains the following formula :
=COUNTA(A3:A99) which yields a value of 7.

The Name is still missing, but it does appear in the "Insert, Define" list.

Bernie
 
Back
Top