Evaluate(Indirect) doesnt work
 

Hi,

I have a value in some cell which has the info.
So I know that I have to use INDIRECT to get the value..

Evaluate is working fine for every case but when I giv
Evaluate("INDEX(H32)"), it gives a run time exception. Could you hel
me to know what I missed out

--
srinu126
-----------------------------------------------------------------------
srinu1264's Profile: http://www.excelforum.com/member.php...fo&userid=3415
View this thread: http://www.excelforum.com/showthread.php?threadid=53950

Evaluate(Indirect) doesnt work
 

first, you say INDIRECT, then your sample uses INDEX

in vba, neither would be necessary.

If you have a range address in H32 and you want to find the value at that
address you would just do

msgbox Range(Range("H32")).Value

--
Regards,
Tom Ogilvy

"srinu1264" wrote in
message ...

Hi,

I have a value in some cell which has the info.
So I know that I have to use INDIRECT to get the value..

Evaluate is working fine for every case but when I give
Evaluate("INDEX(H32)"), it gives a run time exception. Could you help
me to know what I missed out.


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