Sort dynamic range alphabetically - cant get it working

Hi Taktiker,
maybe so

Please Login or Register  to view this content.

This works in the sample book, but it misses a point I didnt mention. It should only sort the text entries until the first empty row. Because in the column is other data that shall not be sorted. This is the reason why I included the LastRow Variable.

then maybe this

Please Login or Register  to view this content.

I just noticed I that the macro has to sort 3 columns without changing the other columns, like e.g. the numbers on the left. I added some other cells to the sample book and marked the area to sort with a red border so you can visualize it more easily. Sorry for not telling you everything from the start.

try again

Please Login or Register  to view this content.

Thanks a lot! This is exactly what I need.