Macro to Order Numerically Then Alphabetically

Originally Posted by smuntl

You are correct.
It does that when i create a 'test sheet' for the macro, but for some reason in my data sheet it removes the cells with letters.

Hi Smuntl;

I believe the first problem is the range that you've identified. The macro isn't necessarily "removing" the data, it's just sorting the Null value higher than some values rather than others.

If you begin your macro with:

Please Login or Register  to view this content.

And then adjust your macro to read something like:

Please Login or Register  to view this content.

That may fix the 'deletions'.

Even if it doesn't really fix anything, it'll curb the scope of the macro down to make it run faster, and help us get to a better solution.

Originally Posted by smuntl

Thanks,

I realised that the letters are going right to the bottom of the spreadsheet. Will try the changes you mention and also look for something to remove those blank cells.

Thanks

The little clause provided just curbs the scope of the macro. The Blank Cells are a biproduct of selecting too much. If you only are trying to sort 3 values, but are selecting 10 cells, it'll sort those 3 within the 10. However, using something like:

Please Login or Register  to view this content.

Will select the LAST value in the column, therefore reducing the scope from a hard-coded 10, to a variable 3.