It will help others help you if you post your complete code.

Also, have you seen this post?
excel - VBA, Combine PDFs into one PDF file - Stack Overflow