Excel Macro to Sort data

[manjuksha]

Hi,

I have two columns Name and Date, i want to sort Name by ascending and Date by Descending, the range is not same, user input is needed to select the data range.
i need excel macro to sort the data, based on user input.

Thanks: Praveen