Sort Macro not working

[garyboy7000]

Hi….first time posting a question…new to this.
Been spending hours reading and trying solve a couple of problems and I sure would appreciate some help.
The Worksheet has a number of “Sort” buttons, all of which are working fine, except one. The “Date”, “Description” and “Action” macro buttons work fine, putting all blank lines to the bottom. The “Symbol” sort button (Column E), for some unknown reason, is putting the blanks at the top. After much playing, I have been able to solve this problem by determining the “LastRow” (constantly changes). I had hoped to combine the row with a static Column (Ai), combining it with the starting cell (A10) for the range to be sorted….it just doesn’t work and, unless I leave the “sort” line out, it gives me the error “COMPILE ERROR: INVALID QUALIFIER”. Seems to be that it doesn’t like “DataRange” being used. If I put in the static range “A10: Ai22” it works. It just doesn’t like the contents of “DataRange” which appears to be the same as the static range mentioned.

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

DataRange is a string, so should be

Please Login or Register  to view this content.

[garyboy7000]

Thanks, Jindon....worked like a charm. Such a simple fix and to think I was playing with it for hours! Many, many thanks!!

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks