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!
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!