ExcelBanter - multi-cell named ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multi-cell named ranges (https://www.excelbanter.com/excel-worksheet-functions/122610-multi-cell-named-ranges.html)

Santa-D

multi-cell named ranges

I have a worksheet with three cells that contain certain values.
What I want to do is to create an array (named range) of the three
cells.

E.g. A1, A2, A3 = myrange

and when I am working in a linked workbook I want to be able to enter
the formula like

=[external workbook]myrange(1) for the value of A2 or ...myrange(0) for
value of A1

Is this achievable?

JMB

multi-cell named ranges

Check help for the INDEX function

"Santa-D" wrote:

I have a worksheet with three cells that contain certain values.
What I want to do is to create an array (named range) of the three
cells.

E.g. A1, A2, A3 = myrange

and when I am working in a linked workbook I want to be able to enter
the formula like

=[external workbook]myrange(1) for the value of A2 or ...myrange(0) for
value of A1

Is this achievable?

All times are GMT +1. The time now is 02:21 AM.