Inconsistent results with SortBy - it toggles between ascending/descending
Sub Sort
set table=ActiveDocument.GetSheetObject("CH05")
table.SortBy 6
set Table =ActiveDocument.GetSheetObject("CH15")
table.SortBy 6
end Sub
This macro sometimes sorts in ascending order and sometimes in descending order. i want to sort only in Descending order. What will be the Macro. Please i need it urgently ??