I am trying to sort my workbook cells B1:H122 (Row 1 is header). The sort is on column E. I'm running a macro named LOOKUP_PLAYER_DATA. The Macro works as intended until it reaches the sort step:
I created the sort step using the 'Record Macro' option into a new macro (TEMP) then copied that sort step into the LOOKUP_PLAYER_DATA macro. The sort worked fine when recording the macro and column E was sorted descending properly, however when I run the macro the sort puts rows with spaces or "" before the rows with actual numbers. Even after I replaced the spaces with 0 in E2:E122 I still have rows with spaces before actual numbers??
I've retried this sequence several times (record new sort macro and retry running it and have gotten same results.
I've copied the macro to a txt file and attached it but the workbook is too large to upload and I deleted over 3000 rows and 8 columns but the workbook is still to large to load, so I hope someone has an idea to try to fix the issue.
I set column E cells to Number with no decimal point.
Thanks for any help you can offer.
Bookmarks