rocheey
05-29-2008, 10:12 AM
I have some workbooks created by others, the format of these workbooks cannot change.
In the first of these workbooks, say "WorkBook 1", there is data written in columnar format on Sheet "1A".
In this same first workbook, but on Sheet "1B", there is a formula written that uses the INDIRECT function to access the data on sheet "1A". Each of the cells on Sheet "1B" that use this function, (all in the same column), each have a unique name (named RANGE).
A second WorkBook, accesses the value of the cells on Sheet "1B" of the first (external) workbook using the '[WorkBook].NamedRange' format.
My question is, is there a way, from WorkBook 2, to get the value of the cell in the Column NEXT to '[WorkBook].NamedRange' in Workbook 1?
Thanks in advance, and help yourself to my aspirin ....
In the first of these workbooks, say "WorkBook 1", there is data written in columnar format on Sheet "1A".
In this same first workbook, but on Sheet "1B", there is a formula written that uses the INDIRECT function to access the data on sheet "1A". Each of the cells on Sheet "1B" that use this function, (all in the same column), each have a unique name (named RANGE).
A second WorkBook, accesses the value of the cells on Sheet "1B" of the first (external) workbook using the '[WorkBook].NamedRange' format.
My question is, is there a way, from WorkBook 2, to get the value of the cell in the Column NEXT to '[WorkBook].NamedRange' in Workbook 1?
Thanks in advance, and help yourself to my aspirin ....