Excel macro help.?

I am creating a macro that I want to sort a set of rows in alphabetical order by Column B. The selection will always start at the same row but will end at a varying number but will always be the third last row. How do I go about making this selection in VBA? Thanks in advance for your help.