I am running these two macros in my spreadsheet in Excel 2007 and they run perfectly. However, my colleague sees a runtime 438 error when she tries to run it in Excel 2003. Any ideas? PLEASE help.
See my macros below:
Macro 1)
VBA Code:
Sub Sort() ' ' Sort Macro
ActiveWorkbook.Worksheets("Value of Incentives by Cust").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Value of Incentives by Cust").Sort.SortFields.Add _ Key:=Range("U19:U80"), SortOn:=xlSortOnValues, Order:=xlDescending, _ DataOption:=xlSortNormal With ActiveWorkbook.Worksheets("Value of Incentives by Cust").Sort .SetRange Range("O19:U80") .Header = xlGuess .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub