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?
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?