Thread
:
refer to specific worksheet
View Single Post
#
1
Posted to microsoft.public.excel.programming
Dirk Nachbar
external usenet poster
Posts: 11
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
Reply With Quote
Dirk Nachbar
View Public Profile
Find all posts by Dirk Nachbar