Hi snb, thanks for your help, your revised VBA code also have me an error.

Apologies Paul for not specifying the number of rows; I will be more mindful of this in future posts.

Pascal thank you very much, that code works just as intended, and rapidly too. Is it possible to have a table 14 columns wide (and 280,000 rows long) to be sorted in this order, based on Column A?