Sorting from lowest to highest by specific column

Greetings, all!

In a nutshell, what I have is a command button which executes code that loops through rows on a different worksheet ("Work Data") and copy/pastes rows that fit the criteria (in this case, user-entered date) into a 3rd worksheet ("Query Output").

This works fine, but I am trying to then sort the rows in ascending order by column "G" (which can have a varying number of rows in it).

If I do this manually and record it as a macro I get the bottom portion of the code below. As it's own module run with a hotkey after the macro pastes data into the Query Output tab, it does the sorting just fine. However, if I stick the same code into the private sub as shown below, I get a "Run-time error '1004', Selected method of range class failed" error.

Am I overlooking something?

Please Login or Register  to view this content.