Excluding a row before sorting

[secondrate]

Hi all, I'm sorting a column named "Offer". The first cell in this column contains the title "Offer" so when I sort this column using a macro I created, the first row gets affected as well. When i sort it according to ascending order, the numerical values are sorted properly yet the "Offer" title is in the bottom for some reason. How do i adjust the range? I intend to use the range named "Offer" rather than a specific one (ie E1:E174) because when this macro will be exported to other workbooks, "Offer" won't always be in column E.

Thanks