refer to specific worksheet
 

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

refer to specific worksheet
 

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

refer to specific worksheet
 

"Dirk Nachbar" wrote in message
oups.com...
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