argument not found

M

MMM

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?
 
R

Rob Bovey

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 *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SpecialCells(xlCellTypeBlanks) = error 1004 No cells found 5
Sort in hidden page crach 8
Runtime error 1004 Application-defined or object defined error" on data sort 1
Code to sort rows getting hung up by merged cells 0
Run-time error '1004' 2
VBA Sort Problem 2
Check Auto Filter - if on, turn off before running macro 4
Sort Marco won't work in 2010 5

Top