Sort Merged

I'm looking for any help in sorting a range of merged cells.

Yes I know merged cells are horrible to use, but they were needed for my layout.

I just need the code to click the button in the attached workbook which will sort the range I specified in the sub Sort_Time from earliest to latest, while keeping the row information intact (Info A, A.1, A.2, A.3 and the time 01:00 will need to stay on the same line, and the same for the rest of the Info lines).

Is this possible?

Thank you so much for your consideration.

Try

Please Login or Register  to view this content.

You have just made my day! Hopefully I can get this to work in my project. Kudos to you!! I thank you for your kind contribution. Reputation+++++++++++++

If you read this and possibly have time if I were to change the range to sort (since my project is different) what would i change (like instead of A4:K10 i needed B7:O26)

Need to see the actual data layouts.

Here is the closest I can get to the layout.

Thank you Jindon!

OK, just one line
change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

That works, but the last two merged rows are not included in the sort.

Ahh, tie, good example.

Please Login or Register  to view this content.

Thank you for the quick responses Jindon! I will give this a try on my project tonight and see what happens. Will post results.