VB sorting keeps expanding the range

[CalvinGraham]

So I've got a function that moves values between two columns. I thought that the quickest way would be to add the value at the bottom of it, expand the range by one row and call the built in sort function:
EndRange.Sort Key1:=EndRange.Cells(1), Order1:=xlAscending, Header:=xlNo
Unfortunately it keeps expanding the range to other nearby data. The other nearby data is the selection index and the "<All values>" bit at the top and the (the range feeds a listbox) so I can't simply seperate the data that easily

Is there some way to force Excel to not expand the sort range area?