Method not found error

[Will03]

Hello I have a new issue here with my programming and wondered if anyone could help resolve the issue... My macro opens a workbook makes some changes (at least is what its supposed to do) and then copies the sheet into my Macro book but I get this error Method or data member not found in the following line:

Please Login or Register  to view this content.

I dont know what is wrong and need some advise. Here is the complete code.

Please Login or Register  to view this content.

[HaHoBe]

Hi, Will03,

you should try and dim all used Variables for any routine and use Option Explicit on top of the procedure.

You never gave any value to wsTPCC in the sniplet you posted, and according to what I guess the variable should read wbTPCC in order to make the code work. Then again, the context is not clear from the sniplet.

Ciao,
Holger

[Will03]

Actually I will post the whole code for better understanding hopefully it will help to clarify my issue a little better...

Please Login or Register  to view this content.

[HaHoBe]

Hi, Will03,

just guessing:

Please Login or Register  to view this content.

Ciao,
Holger

[Will03]

Still get the same error but I believe its because the sheet does not have the name yet... So confusing...

Please Login or Register  to view this content.

[Norie]

wsTPPC is declared as a worksheet, worksheets don't have a Sheets property/method.

Also, as far as I can see, you never actually give a value to wsTPCC or assign it to reference anything.