Sort Macro

[RandyD123]

I have a calender that I use for each month. There is one tab or sheet for each month. In that calendar I have a flight schedule for each day. I have to sort the time column for each day so I recorded this macro:

Please Login or Register  to view this content.

This macro then calls on AutoSort2 and continues to sort the time column. My problem is that I want this macro to work on all sheets, but ONLY on the active sheet. As I said, I will have 12 tabs, one for each month and they will be named: 2014-01, 2014-02, 2014-03.........blah, blah...!!! One thing I did't mention is that the time column uses times that are simply text numbers: 100, 200, 300.....1445, 1650, 2300. If you add these times in the time colum, out of order and run the code it will sort them times as well as whole square so the flights still match. What do I need to do to make this work for each sheet.

Moderators note: code tags added for you - this time

[Solus Rankin]

Will the ranges be the same in all sheets?

[RandyD123]

yes every sheet is the same,it is a 7 x 6 grid Sunday - Saturday, the dates will change but....b232 is always b232 on every sheet....that was just an example! I did upload the actual sheet with code embedded.

[Solus Rankin]

Everywhere you have Activeworkbook.sheets(sheetxyz) will have to be changed to activeworksheet. I'd change it for you but I'm replying from my phone.

[RandyD123]

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[RandyD123]

I must have done it wrong, I tried it but I got a "required object" error!!

[nilem]

Randy,
ActiveSheet, not ActiveWorksheets

[RandyD123]

Thank you, it worked!!