Sort words between strings "Start" and "End"

[jokris]

I have to sort every value after row 9 which contains "Start" and before last text string "End" (two rows above "End") in three different sheets. This code works if "End" is hidden, but I would like to do this when "End" is shown instead. Otherwise "End" is sorted with the values after row 9.

I want "End" (the last text string) to stay at the same place after the sorting, not to be affected by the code.

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.