Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Handling - Infinite loop
Hi My "Excel 4 Macro" Error handler goes into a infinite loop, i'm no sure why My macro code is Under Auto Open I define the error handler as below AUTO_OPE =ERROR(2;RECOVER The Error Handler RECOVE =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 Aru -- coder_aru ----------------------------------------------------------------------- coder_arun's Profile: http://www.excelforum.com/member.php...fo&userid=3381 View this thread: http://www.excelforum.com/showthread.php?threadid=56822 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Handling - Infinite loop
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Infinite Loop in Error Handler | Excel Discussion (Misc queries) | |||
Error Handling - Infinite loop | Excel Programming | |||
Newbie Q: Error handling procedures in a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Infinite Loop | Excel Programming |