Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Error Handler disabled & Complete Range not in Memory

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    London / NZ
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    SRC
    Posts
    165
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •