Sorting - how to select part of worksheer

I am trying to create a VBA Macro that sorts the data on a worksheet.

I have 10 rows of header junk that I want left as is, then 300 to 500 rows of
data I want sorted - on data of a particular column.

Right now its 340 ... and this works (sorting on col M)

Please Login or Register  to view this content.

What if I go past 1000 rows ? So, I wanted a way to make it work for any number of
rows. I tried this,

Please Login or Register  to view this content.

but my header data in row 10 ended up getting pushed to the very last row. It apparently
was included in the sort.

How can I get this done correctly ?

Please Login or Register  to view this content.

Regards, TMS

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save