Select Method of worksheet class failed Error - VBA

Hi,

I'm encountering Select Method of worksheet class failed Error while running below vba code:

It failed on Sheets(strSheetName).Select

Please Login or Register  to view this content.

I need to select sheets T0 – T9 & PN.

(Please see attached file)

The following sheets are not visible & don’t need to select:

Sheet 12 (tmpscrapsheet)
Sheet 13 (Ls_XLB_WorkbookFile)
Sheet 14 (Ls_AgXLB_WorkbookFile)

Hope you can help me.


Thanks!

Jeff

Hi,

For starters, you have uploaded a Word document, not an Excel workbook.

Secondly, what is the value of strSheetName when the code fails, as you haven't excluded tmpscrapsheet from the If...Then conditional statement previously.