Trying to sort using a variable for length of spreadsheet

[Fyredancer]

I am trying to perform a sort on a spreadsheet that is of varying lenght. There are 14 cells at the bottom that do not change and must remain at the bottom of the spreadsheet and unsorted. I am using a variable to determine the last row to be sorted. When I run the macro I get the error message "The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort By box isn't the same or blank." Row 3 of the spreadsheet is my header row that I am using to sort by.

Please Login or Register  to view this content.

[patel45]

you selected range A3:P" & Final, but you used it only at the end, why ?
can you attach a sample file for testing ?

[JosephP]

perhaps

Please Login or Register  to view this content.

[Fyredancer]

Problem has been solved. My boss neglected to tell me there were hidden formulas in the spreadsheet (several screens down from the data I was trying to sort!) Once I compensated for those everything works great. Thanks for the assistance. Here how my final code looks:

Please Login or Register  to view this content.