debug help

[blueflinko]

I am getting a run time error at this line:

Selection.Sort Key1:=Range("K2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal


Anyone see my error?

 

[Tom Urtis]

This line here
DataOption1:=xlSortNormal
came along with version xl2002, and when it is included with macros being run on systems that use a version prior to 2002, those users will get an error.

You probably recorded that sort macro on one computer using Excel2002 or 2003, and are running it on a different computer using an earlier version of Excel, such as Excel2000 or 97.

Just delete that argument and you should be fine.

This post looks like a duplicate of this one, which is regarded as an inconsiderate annoyance on message boards.
http://216.92.17.166/board2/viewtopic.php?t=79249