General discussion
June 20, 2002 at 08:33 AM
lf king

Macros Excel 97 versus Excel XP

by lf king . Updated 24 years, 2 months ago

The lines listed below are in a macro in Excel XP. It runs fine there, but will not run in 97.
Selection.Sort Key1:=Range(“A8”), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Why would it run in one but not the other?

This discussion is locked

All Comments