Adding a named range to a cell

[John]

This question is about concatenation and named ranges. On sheet2 of my
workbook, I have a value in a cell named Eddie1. On sheet1, I would
like to have a formula generated in a cell as: "=Eddie1". I use the
word "Eddie" at the top of Column B, and have the numbers 1 through 43
running down the A column. So I thought I could concatenate an = sign,
the name Eddie and the number 1, and come up with the formula
"=Eddie1". It works, in so much as it puts the text "=Eddie1" in the
cell, but it's not a formula.

What am I doing wrong?

Thanks
John

 

[keepITcool]

you'll need indirect to force the evaluation of the string to a reference

=indirect("eddie" & 1)



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >