| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell 2007 / 2003 Compatability Issue | Excel Worksheet Functions | |||
| Compatability Issues between 2007 and 2003 | Excel Discussion (Misc queries) | |||
| 2007 Compatability Pack for Office 2003 | Excel Discussion (Misc queries) | |||
| Office 2003 and 2007 compatability install | Excel Discussion (Misc queries) | |||
| Excel compatability 2003-2007 | Setting up and Configuration of Excel | |||
Threaded Mode
