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

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