Hi,

I've got a sheet where I want to select and then sort, via a macro, a
colum of data.
It always starts at "A11", but the end is always different.
How do I select this and then sort it this way that the data behind it
(in colum "B11:E11" till the end) will follow.

I have this code, but for some reasson only the selected colum will
sort, the data in the collums behind it will not follow.

Range("A11").Select
Range(Selection, Selection.End(xlDown)).Sort Key1:=Range("A11"),
Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Can somebody please help me out?
Either by changing this code, or a total different solution.

Regards,
Maus