View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rick is offline
external usenet poster
 
Posts: 334
Default 2007 v 2003 compatability

I have written a macro ing Excel 2007, but when we try to run it using 2003
it falls over.

This is the first line of code it stops at. We are trying to sort on Row 1.

ActiveWorkbook.Worksheets("SAP ZAUMAT - WORKING").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("SAP ZAUMAT - WORKING").Sort.SortFields.AddKey:=_
Range("A1:AM1"), SortOn:=xlSortOnValues, Order:=xlAscending,
DataOption:=_xlSortNormal

(Sorry about the way it looks here)

How does this translate to 2003? Should it be different?

Thanks
Rick