+ Reply to Thread
Results 1 to 3 of 3

Run time error 1004 skip

Hybrid View

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    45

    Run time error 1004 skip

    Hi All,
    I dont want to get run time error 1004 message. How can i hide or skip 1004 message automatically. I know that what it means but normally it should be because I am doing unexpected treatment. Macros are correct and This is normal process notwithstanding I want to hide or skip this error message. Could you please help me. Thanks.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,279

    Re: Run time error 1004 skip

    Hi elevisse,

    You need to learn the "On Error GoTo" statement. See http://www.cpearson.com/excel/ErrorHandling.htm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    45

    SOLVED Re: Run time error 1004 skip

    Hi MarvinP,
    Thanks for your help. Problem solved.

    Sub Test()
    Dim Stuff
    'assign variables
       On Error GoTo ErrHandler:
       'your code
    ErrHandler:
     If Err.Number = 1004 then
       ErrMsg = Error(Err.Number)
         Exit Sub
     End If
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1