Error on some machines ... VBA Sort function

  • Thread starter Thread starter William DeLeo
  • Start date Start date
W

William DeLeo

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.
 
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.
 
You must log in or register to reply here.

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

"Runtime error 1004 Application-defined or object defined error" on data sort 0
Error only on some machines ... VBA Sort function 3
Sorting Macro Loop 2
Sort error? 2
SpecialCells(xlCellTypeBlanks) = error 1004 No cells found 5
Writing a Sort Macro 4
Sort in hidden page crach 8
protect unprotect sheet vba 3

Back
Top