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.

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

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.

Hi Teaker,

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

Thanks!