Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel hangs...
Hi I need some guidance regarding this. I have a Excel sheet that with a SELECT macro of the form. =SELECT("R1C1,R2C1,R3C1") The problem is that the list seperator is , in this case and ; for the OS. When I try to apply the macro Excel hangs and I have to kill it from the task manager. I guess some exception is being thrown that I an not handling. I want to know: 1. How to handle exceptions in Excel ( I'm not using VBA) 2. What kind of Exceptions should be handled. Thanks in advance Arun -- coder_arun ------------------------------------------------------------------------ coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 View this thread: http://www.excelforum.com/showthread...hreadid=535851 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel hangs...
My Excel2K does not have a function called SELECT.
What are you trying to achieve ? Maybe you need the CHOOSE or MATCH functions. NickHK "coder_arun" wrote in message ... Hi I need some guidance regarding this. I have a Excel sheet that with a SELECT macro of the form. =SELECT("R1C1,R2C1,R3C1") The problem is that the list seperator is , in this case and ; for the OS. When I try to apply the macro Excel hangs and I have to kill it from the task manager. I guess some exception is being thrown that I an not handling. I want to know: 1. How to handle exceptions in Excel ( I'm not using VBA) 2. What kind of Exceptions should be handled. Thanks in advance Arun -- coder_arun ------------------------------------------------------------------------ coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 View this thread: http://www.excelforum.com/showthread...hreadid=535851 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel hangs...
It looks like the OP is using the older XLM macro--not VBA.
(I don't know anything about them, either!) NickHK wrote: My Excel2K does not have a function called SELECT. What are you trying to achieve ? Maybe you need the CHOOSE or MATCH functions. NickHK "coder_arun" wrote in message ... Hi I need some guidance regarding this. I have a Excel sheet that with a SELECT macro of the form. =SELECT("R1C1,R2C1,R3C1") The problem is that the list seperator is , in this case and ; for the OS. When I try to apply the macro Excel hangs and I have to kill it from the task manager. I guess some exception is being thrown that I an not handling. I want to know: 1. How to handle exceptions in Excel ( I'm not using VBA) 2. What kind of Exceptions should be handled. Thanks in advance Arun -- coder_arun ------------------------------------------------------------------------ coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 View this thread: http://www.excelforum.com/showthread...hreadid=535851 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel hangs on calculation | New Users to Excel | |||
Excel hangs up. | Excel Discussion (Misc queries) | |||
Excel hangs | Excel Programming | |||
Excel Hangs | Excel Discussion (Misc queries) | |||
FileSearch Hangs Excel | Excel Programming |