Dear all
I want to refer to a cell in a worksheet by writing down the worksheet
in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
formula =sheet2!A1
as a string and not evaluate it.
Dirk
Dear all
I want to refer to a cell in a worksheet by writing down the worksheet
in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
formula =sheet2!A1
as a string and not evaluate it.
Dirk
hi
use INDIRECT function
"Dirk Nachbar" wrote:
> Dear all
>
> I want to refer to a cell in a worksheet by writing down the worksheet
> in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
> formula =sheet2!A1
> as a string and not evaluate it.
>
> Dirk
>
>
"Dirk Nachbar" <[email protected]> wrote in message
news:[email protected]...
> Dear all
>
> I want to refer to a cell in a worksheet by writing down the worksheet
> in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
> formula =sheet2!A1
> as a string and not evaluate it.
>
> Dirk
>
Try =INDIRECT(A2&"!A1")
Cheers,
Joerg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks