Sorting Question

[kop442000]

I want to have a button that will "sort" all the data in my ever growning spreadsheet but column B.

No I know how to do a macro to do this, but after I create the macro and more and more lines of data are added, the macro will not encompass all the new lines.

I realise that in the macro I could scroll alllll the way down to the bottom to make sure that every line is counted but this seems a bit extreme.

I can't sort by highlighting the column header things either, because the data I want to sort only starts on line 5 and so I don't want to include any lines before this.

Is there an easier way that to highlight and sort all the lines all the way to the bottom?

Thanks for any replies posted.
Kop.

 

[arthurbr]

You should use a dynamic named range ' see http://www.contextures.com/xlNames01.html and use the name somewhere in your code.
Not being a VBA man myself I wouldn't really know how.
Hope this will get you started