Run Time Error 438

[guitarsweety]

Can anyone tell me why I'm getting this error, “Object doesn't support this property or method” (run-time error 438)

Please Login or Register  to view this content.

[jolivanes]

I assume that "AuditTeam" are the sheet names
Change to

Please Login or Register  to view this content.

[guitarsweety]

Thank you so much. I'm not getting the error any longer, but how can I make it copy the used range in column a to the closed workbook

[jolivanes]

You could try this.
It should copy all of your used range in column A to the first empty cell in column A in the other workbook.

Please Login or Register  to view this content.

In your original code you only copied cell A1 [Cells(1, 1)]

[guitarsweety]

I tried the code, but now it's only copying the header row from the closed workbook to row 2. What I really need is for it to copy the used range in column A into the same column of the closed workbook. Attachment 331270

[jolivanes]

My bad. Sorry about that.
Try this instead.

Please Login or Register  to view this content.

If you don't need to append in Column A, change this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[guitarsweety]

Thank you soooooooo very much jolivanes ! I've been struggling with this for weeks now. It works like a charm

[jolivanes]

Sorry about my previous mistake but if you're happy with it, that's all that counts.
Good luck.
John

Could you be so kind and mark it as solved please.

[guitarsweety]

Thank you again. I tried to mark it as solved but it says it already is. I'll post my completed projected shortly.

[guitarsweety]

Attachment 331370
Here is my completed project. I learned so much from this and want to thank everyone here in this forum for all of their contributions.