Macro will not run in all worksheets

Hello gentlemen:

First time poster. I want to thank everybody in advance for your help.

I recorded a macro to sort a selection. The macro works fine in the worksheet where I created it but it won't work in other worksheets in the same workbook. I think I see the problem but I can't figure out how to fix it. The code spells the name of the worksheet where it was created. I tried different things but nothing works. The code currently runs on worksheet "TDL". I want it to run on "KPI" and "MSC". Here is the code (I hope I'm doing this correctly):

Please Login or Register  to view this content.

Thank you TMS. Unfortunatelly it did not work. Thanks for trying though.

Good point TMS. I apologize for that. When I use the code you provided the macro stops working. No it will not sort even in the original worksheet (TDL). It won't work in any of the others either.

Also, i just figured out that my original macro was running on the original worksheet where it was created (TDL) every time. So for example, I would go to worksheet "KPI" make a selection and run the macro, it would sort the range I selected on "KPI" but in "TDL".

In regards to selection (TopLeft...) I created so that it would run in whatever I select each time. That part works fine.

Thank you,

Gonzalo