EXCEL VBA CODE Write Subprocedures GenericSortSetup and Gen

EXCEL VBA CODE :

Write Sub-procedures Generic_Sort_Setup and Generic_Sort to sort a set of values regardless of the size or the address of the data.

Solution

Answer: Note: inbuilt values are used for Implementing the Generic sort Code: ‘Implementation of the Generic sort function Sub GenericSort(ps_rangeVal as string, ps_startVal as string) \' Implements the generic macro Range(ps_rangeVal).Sort Key1:=Range(ps_startVal), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal \' sort defines the sort data \' key1: range defines the key value ‘Sorts the ascending order ‘Indicating the header used row ‘Custom order defines from right to left End Sub