** Imp ( can we use INDIRECT to access cells in other worksheet in the same workbook)
 

Hi Pls let me know this

** Imp ( can we use INDIRECT to access cells in other worksheet in the
same workbook)

I am surprise to see that

EVALUATe("INDIRECT("H23")") works but
EVALUATE("INDIRECT("Formulas!H23 doesnt work)


--
srinu1264
------------------------------------------------------------------------
srinu1264's Profile: http://www.excelforum.com/member.php...o&userid=34155
View this thread: http://www.excelforum.com/showthread...hreadid=539507

** Imp ( can we use INDIRECT to access cells in other worksheet in the same workbook)
 

If formulas is the activesheet, it works. using
Formulas!H23,

If you want to do refer to Formulas from another sheet

s = "Index(Formulas!H32,1,1)"
? evaluate(s)
A1

But again, this would be much slower than just doing

Range(s)


? Range(s)
A1

--
Regards,
Tom Ogilvy

"srinu1264" wrote
in message ...

Hi Pls let me know this

** Imp ( can we use INDIRECT to access cells in other worksheet in the
same workbook)

I am surprise to see that

EVALUATe("INDIRECT("H23")") works but
EVALUATE("INDIRECT("Formulas!H23 doesnt work)


--
srinu1264
------------------------------------------------------------------------
srinu1264's Profile:
http://www.excelforum.com/member.php...o&userid=34155
View this thread: http://www.excelforum.com/showthread...hreadid=539507