Reffering to named cells
 

I have given some cells different unique names in the name box. The name of
the cell is also a text string in an other cell. (Witch changes with certain
criteria.) How can I make a function or formula use the text string to refer
to the named cells?

Reffering to named cells
 

If your text string is in A1, use: =INDIRECT(A1)

HTH
--
AP

"Zulupiper" a écrit dans le message de
news: ...
I have given some cells different unique names in the name box. The name of
the cell is also a text string in an other cell. (Witch changes with
certain
criteria.) How can I make a function or formula use the text string to
refer
to the named cells?

Reffering to named cells
 

Thanx. Solved my problem.

Ardus Petus skrev:

If your text string is in A1, use: =INDIRECT(A1)

HTH
--
AP

"Zulupiper" a écrit dans le message de
news: ...
I have given some cells different unique names in the name box. The name of
the cell is also a text string in an other cell. (Witch changes with
certain
criteria.) How can I make a function or formula use the text string to
refer
to the named cells?