Arun, why go to all the trouble of learning obsolete XLM macro's?
Makes more sense to learn VBA...
The infinite loop is caused by an error in the error handler itself.
the r1c1 address s/b "R[1]C" not "R[1]C[0]\"
Also it makes more sense to use the offset function,
rather than a double conversion (ref-txtref))
=GOTO(OFFSET(LAST.ERROR(),1,0))
forget the =return() in the error handler:
excel will never reach it.
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
coder_arun wrote in
<news:<coder_arun.2c06xp_1154674504.4752@excelforu m-nospam.com
Hi,
My "Excel 4 Macro" Error handler goes into a infinite loop, i'm not
sure why:
My macro code is:
Under Auto Open I define the error handler as below:
AUTO_OPEN
=ERROR(2;RECOVER)
The Error Handler:
RECOVER
=GOTO(ABSREF(\"R[1]C[0]\";LAST.ERROR()))
=RETURN()
Any help on why dose this error handler go into a infinite loop?????
Many Thanks in Advance.
Arun