I would like to use a worksheet validation list with the opSort_Single_Column_of_a_Table.xlsmtion "xlAscending, xlDescending" to sort a table column as follows:
Worksheets("data").Range("data").Sort Key1:=Range("b3").Value, _
However, I get the ERROR message:
Sort method of Range class failed"
Would appreciate any help.
PS: I am attaching the workbook