how to stop "On error resume next" ?

Discussion in 'Microsoft Excel Programming' started by Guest, Feb 10, 2005.

  1. Guest

    Guest Guest

    Hello,
    Does anyone know how to make that:
    Application.displayerror = false (like: On error resume next)
    If Dir("D:\temp\") = "" Then
    Exit Sub
    End If
    If (error.count = 1) then
    exit sub
    endif
    Application.displayerror = true

    I can make a: On error resume next at the beginning but how can I say, On
    error resume next = False ?
    Thanks,
     
    Guest, Feb 10, 2005
    #1
    1. Advertisements

  2. Guest

    JE McGimpsey Guest

    use

    On Error GoTo 0
     
    JE McGimpsey, Feb 10, 2005
    #2
    1. Advertisements

  3. Guest

    Tushar Mehta Guest

    On Error GoTo 0

    that is goto zero.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions
     
    Tushar Mehta, Feb 11, 2005
    #3
  4. Guest

    Guest Guest

    Thanks a lot!
    does a way to improved my prog ?
    On Error Resume Next
    If Dir("V:\Ace\") = "" Then
    Exit Sub
    End If
     
    Guest, Feb 11, 2005
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.