Excel - CallbyName type functionality in named ranges?
Posted on 2000-05-02
Hi - this may be a little complicated to explain, but I'll give it a go.
1) Say I have a named range of one cell called "MyRange" which will contain the number of the month of the year.
2) I also have a row Jan, Feb, Mar, Apr etc, denoting the months of the year, and under each month is some sort of monetary value for that month. E.g.
Jan Feb Mar
123 456 789
3) Now, I want another cell to reference the amount for the month number in the named range "MyRange". Its cecll formula may be something like - "=MyRange:3". This obviously doesn't work, but may be similar to call by name in VB6. Does anyone a) understand what I'm going on about and b) know if you can do this easily?