Run-time error '9': Subscript out of range

[Maxpsb47]

Hi Excel Experts,

Does anyone know why I'm getting this error after I run my macro?

I recorded a Marco to clean up a .csv file into a workable format. I am able to run the Marco on other spreadsheets with no problem but get an error message (as shown in attached picture). I've included the section of the Macro that sorts both columns B & A; which the error is originating from.

[TMS]

Check the spelling of the worksheet name and make sure the worksheet is present in the active workbook.

[Maxpsb47]

Oh ok, it was the date at the end of the worksheet name "2021-05". I just need to remove the date before I run the Macro which solved the problem.

Thanks for you response.

[TMS]

You're welcome. Thanks for the rep.