Excel hangs...

[coder_arun]

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

 

[NickHK]

My Excel2K does not have a function called SELECT.
What are you trying to achieve ? Maybe you need the CHOOSE or MATCH
functions.

NickHK

 

[Dave Peterson]

It looks like the OP is using the older XLM macro--not VBA.

(I don't know anything about them, either!)