Sorting with Buttons

I'm having an issue with the VBA Sort function when using a button to activate the Sort. The code seems to work one time when I first try it, but then does not work after that.

Columns A-G need to be sorted based on data in column D for "Symbol" button, or column E for "Entry Date" button. I am using cell names to indicate location as this "Jumper" section will move down the sheet as more records are added above. (and columns B & C are blank and need to remain blank)

Here is the code that is not working, and I have attached a stripped down version of the document. The macros in question are entitled "Sort_Jumper_Symbol" and "Sort_Jumper_Entry".

What am I doing wrong?

Please Login or Register  to view this content.

Thanks Leith! That is sorting correctly, but it is only sorting columns D-G. I need A-G sorted, but can't figure how to adjust your code to do that.

That's not working, I get "Run-time error '1004': 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." When I click "Debug" it highlights the code line ".Apply"

Thanks, it works now!