OFFSET Range
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 |
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 |
All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com