Issue with Sorting a Range: Sort method of Range class failed

Hi,

I am trying to sort a range of data that starts in Column A and goes to Column AT (including this column). The data I want to sort starts on the second row as I have the first row as a header. The last row of my data is constantly changing as rows get added. The last row of data will be in FirstBlankRow as that is the row that was just filled with the data via my macro.

Currently my code is adding my data to FirstBlankRow but it is not sorting the data afterwords. I keep getting Run-time error '1004': Sort method of Range class failed

Please Login or Register  to view this content.

Any help is greatly appreciated!

Thanks for your response, I was about to try it when I realized the sheet I was trying to sort was protected with a password. I unprotected the sheet and my original code works perfectly now.