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