Hi,
I have a large amount of code which error's when running in Excel 2003. (it does not sort, whereas in 2007 it does).
As i don't have Excel 2003 can someone tell me which part of my code does not run in Exccel 2003 please:
Range("E5").Activate
ActiveWorkbook.Worksheets("BranchList").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("BranchList").Sort.SortFields.Add Key:=Range("E5"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("BranchList").Sort
.SetRange Range("B6:AE65513")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Thanks
Bookmarks