Experiencing "Run Time Error 438: 'Object doesn't support this property or method'"

[BYizz]

Hello,

I need to copy a sheet from a closed workbook and am using the following code to do so.

Please Login or Register  to view this content.

When I run the code I get the Run Time Error 438: 'Object doesn't support this property or method" when I run the code. Debugging highlights the 5th line "wbSource.Sheet1.Copy After: =wbTarget.Sheets1", so it must be something dealing with that. Do I need to enable other objects? Not sure how to fix this...

[watersev]

hi BYizz, try to amend this line:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

where Sheets1 and Sheet1 are names of the sheets concerned

You can not refernce a sheet within object by its codename

[AlphaFrog]

Another example...

Please Login or Register  to view this content.

[BYizz]

Awesome. That was an easy fix, thanks for your help guys!