Excel VBA How To Sort ARRAY

[kashif.special2005]

Hi,

I have data in a array variable with 8 columns, and I want to sort the array with condition, like

there is one of two columns in the array one is TA_Name and second is Trans_Date and want to sort the data as Ascending order (TA_Name) and Descending order (Trans_Date) or Ascending order (TA_Name) and Ascending order (Trans_Date).

I have no idea how to do this in Array with VBA.

Kindly request to all VBA expert, please help me achieve this task.

Thanks in advance.

Thanks
Kashif