multi-cell named ranges

  • Thread starter Thread starter Santa-D
  • Start date Start date
S

Santa-D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

simple counting gone awry 3
Counting coloured cells 3
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Vlookup and return sheet name also 2
Excel VBA setting Ranges 2
Defining cells that macro will change 2
Using names referencing a cell in another workbook 2
Copyit Macro 16

Back
Top