argument not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a spreadsheet with numerous macros. I have used these macros
numerous times on different pc's. I emailed the file to another individual
and when they run the macros they get an error: Name Argument Not Found:
Data Option 1:=x1sorttextasnumbers.

This is the macro where the error is:
Range("K1").Select
Range("A1:N110").Sort Key1:=Range("k1"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortTextAsNumbers

Can you help me?
 
The DataOption1 argument to the Range.Sort method first appeared in
Excel 2002 (XP). The person experiencing the problem is probably running an
earlier version of Excel. You'll need to delete this argument from your
macro in order for it to run on all current versions of Excel..

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* Unsolicited e-mail replies will be ignored *
 
Back
Top