+ Reply to Thread
Results 1 to 5 of 5

Run-Time Error Object Required

  1. #1
    Forum Contributor
    Join Date
    10-16-2012
    Location
    Brooklyn
    MS-Off Ver
    Excel 2010 PC
    Posts
    137

    Run-Time Error Object Required

    Hi,

    I recorded this Macro and am encountering a Run-time error '424': Object required in the below code. Can anyone tell me what object I'm missing.

    Please Login or Register  to view this content.
    Any help is appreciated.

    Thanks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-Time Error Object Required

    The missing object is probably the Sheet3 because that isn't the name of the new worksheet you added.

    Change Sheet3 to ActiveSheet.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Run-Time Error Object Required

    Worked without any problem for me as long as you have a tab named "Var"
    If you found this helpful, click the star

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-Time Error Object Required

    Doesn't work for me when there's a sheet called 'Var' and the new sheet added has the codename Sheet6.

  5. #5
    Forum Contributor
    Join Date
    10-16-2012
    Location
    Brooklyn
    MS-Off Ver
    Excel 2010 PC
    Posts
    137

    Re: Run-Time Error Object Required

    Thanks guys, I got it worked out. I was having a problem with renaming my sheets inside the Macro in the beginning.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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