View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
srinu1264[_5_] srinu1264[_5_] is offline
external usenet poster
 
Posts: 1
Default ** 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