Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a named range to a cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a named range to a cell
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 (John) wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
named cell range | Excel Worksheet Functions | |||
Adding to a named range on another worksheet | Excel Programming | |||
need help adding named range as new series to a graph | Excel Programming |