Error Handler disabled & Complete Range not in Memory

[dognz]

Here is a tricky one - I have a large Do-loop executing, I have a error handler that should be used when the last cell in a visible range is about to be tested (becuase error will occur).

There are two problems, the first is that the entire visible range is not being recognized - the last 1000 cells are being listed as a range i.e a8000:a9000 rather than individually i.e a8000,a8001 etc. The error occurs at this point.

Regardless of the first problem I have a error handler that should execute and direct the code - somehow this error handler is disabled??? I have checked my error handler options and all is in order.

Appologies if this has not been explained clearly - will be happy to give further details if anyone has any ideas on this one!

 

[JohnG]

Have you got a sample of the code it might give me an idea whats wrong

On 2002-02-20 07:42, dognz wrote:
Here is a tricky one - I have a large Do-loop executing, I have a error handler that should be used when the last cell in a visible range is about to be tested (becuase error will occur).

There are two problems, the first is that the entire visible range is not being recognized - the last 1000 cells are being listed as a range i.e a8000:a9000 rather than individually i.e a8000,a8001 etc. The error occurs at this point.

Regardless of the first problem I have a error handler that should execute and direct the code - somehow this error handler is disabled??? I have checked my error handler options and all is in order.

Appologies if this has not been explained clearly - will be happy to give further details if anyone has any ideas on this one!