OFFSET Range
Is SIM5 a worksheet?
If so, maybe
=INDIRECT("'"&LEFT(A1,FIND("$",A1)-1)&"'!"&MID(A1,FIND("$",A1),99))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Daniel" wrote in message
...
I have the following string in cell A1:
SIM5$A$1
I would like to use it as a range for offset and does not work, I suppose
because it is a string and not a range.
Question: how do I make it into a range to be able to use offset
thanks
|