Thread: Sort code fails
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ordnance1 ordnance1 is offline
external usenet poster
 
Posts: 52
Default Sort code fails

Can anyone tell me why this code fails in Excel 2003 (works fine in Excel 2007)

I get the following error:

object doesn't support this property or method

and the line ActiveSheet.Sort.SortFields.Clear is highlighted


Sub Sort_NoneReturned()
'
'

'
Application.EnableEvents = False
Application.ScreenUpdating = False

ActiveSheet.Sort.SortFields.Clear
ActiveSheet.Sort.SortFields.Add Key:=Range( _
"O3:O5000"), SortOn:=xlSortOnValues, Order:=xlAscending,
DataOption:= _
xlSortNormal
With ActiveSheet.Sort
.SetRange Range("A2:O5000")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

Range("B2").Select

Application.EnableEvents = False
Application.ScreenUpdating = True

End Sub