Results 1 to 8 of 8

Thread: Difference Between 'On Error GoTo 0' And 'On Error GoTo -1'

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,456
    Rep Power
    10
    .
    . Hi,
    . A Couple of follow up questions.

    . 1 ) Would you describe On Error GoTo 0 and On Error GoTo -1 as error statements,
    And
    . 2 ) On Error Resume Next and On Error GoTo some_label/line_number as error handlers.
    . Thus we have in VBA 2 types of “error handlers”. I ask as the literature is often confusing, ( possibly caused partly by the GoTo 0 and GoTo -1 which do not actually “go anywhere” I believe ).
    . One is often mislead in thinking in terms of 4 “error handlers”

    Thanks
    Alan
    Last edited by DocAElstein; 05-27-2015 at 08:55 PM. Reason: Editor lost some spaces between words!!??

  2. #2
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,456
    Rep Power
    10
    P.s. Just for info: Similar Blog is here
    On Error WTF? | Excel Matters

    Edit April 2018
    Also see here:
    http://www.excelfox.com/forum/showth...GoRoT-N0Nula-1
    Last edited by DocAElstein; 05-07-2018 at 02:06 PM.

Similar Threads

  1. Get External Data Error
    By marreco in forum Excel Help
    Replies: 2
    Last Post: 01-05-2013, 08:20 PM
  2. #Value Error in Working File
    By Suhail in forum Excel Help
    Replies: 2
    Last Post: 11-19-2012, 11:39 PM
  3. Swapping columns Error 2
    By jomili in forum Excel Help
    Replies: 1
    Last Post: 11-16-2012, 08:52 PM
  4. Excel Error
    By aarbuckle in forum Excel Help
    Replies: 5
    Last Post: 03-13-2012, 03:12 AM
  5. On Error Statement (Visual Basic)
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 10-12-2011, 09:06 AM

Posting Permissions

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