+ Reply to Thread
Results 1 to 5 of 5

Runtime Error 424 - Object Required

  1. #1
    Registered User
    Join Date
    05-21-2009
    Location
    Ok, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Runtime Error 424 - Object Required

    Hey guys & gals.. I am getting a runtime error 424: Object required on the line "For Each ws In memberLists.Worksheet"

    The entire code is below. How can I fix this?

    Please Login or Register  to view this content.
    Last edited by teaker; 06-09-2009 at 04:02 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Runtime Error 424 - Object Required

    Are you calling the CopyToChapter sub from anywhere else where the newMembers workbook hasn't been defined?
    Martin

  3. #3
    Registered User
    Join Date
    05-21-2009
    Location
    Ok, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Runtime Error 424 - Object Required

    Not that I know of... this is the only macro in the workbook.

  4. #4
    Registered User
    Join Date
    05-21-2009
    Location
    Ok, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Runtime Error 424 - Object Required

    Solved! Thanks Guys! I believe I was calling the CopytoChapter sub from another place in my workbook... Now I am having a different problem that causes excel to stop responding after the macro runs. I will post the final code here when I get this darn thing figured out.
    Last edited by teaker; 06-15-2009 at 01:10 PM.

  5. #5
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Runtime Error 424 - Object Required

    Hi Teaker,

    Would you be so kind as to share your resolution with the forum? Other members may benefit from your findings.

    Thanks!

+ 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