Error on some machines ... VBA Sort function
 

Greetings,

I prepared a spreadsheet with macros for a client and an error surfaces
on their machines but not mine. They are running Excel 2000 and I am
running Excel 2002. Since I can’t spend that much time on their
computer troubleshooting the problem, I am in a *really* bad
situation.

Any guidance would be greatly appreciated.

When the following code is executed on their machines (line breaks
added for posting),

Sheets("Materials Archive").Range("A:G").Sort
Key1:=Worksheets("Materials Archive").Columns("A"),
Order1:=xlAscending, Header:=xlYes,
OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

I get the following message referring to all the above code:

“Run-time error 1004
Application-defined or object-defined error.”

Thanks in advance.


---
Message posted from http://www.ExcelForum.com/

Error on some machines ... VBA Sort function
 

See answer to your first posting of this question. You are using an
argument added in xl2002 (Dataoption1) which is not recognized in xl2000 and
causes the error. Delete the argument.

--
Regards,
Tom Ogilvy


"William DeLeo " wrote in
message ...
Greetings,

I prepared a spreadsheet with macros for a client and an error surfaces
on their machines but not mine. They are running Excel 2000 and I am
running Excel 2002. Since I can't spend that much time on their
computer troubleshooting the problem, I am in a *really* bad
situation.

Any guidance would be greatly appreciated.

When the following code is executed on their machines (line breaks
added for posting),

Sheets("Materials Archive").Range("A:G").Sort
Key1:=Worksheets("Materials Archive").Columns("A"),
Order1:=xlAscending, Header:=xlYes,
OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

I get the following message referring to all the above code:

"Run-time error 1004
Application-defined or object-defined error."

Thanks in advance.


---
Message posted from http://www.ExcelForum.com/