Error on only some machines ... VBA Sort function

W

William DeLeo

Greetings,

I prepared a spreadsheet with macros for a client and an
error surfaces on their machine 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 machine (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.
 

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 1
Code to sort rows getting hung up by merged cells 0
VBA Sort Problem 2
Sorting Macro Loop 2
Sort in hidden page crach 8
Run-time error '1004' 2
Sort error? 2
SpecialCells(xlCellTypeBlanks) = error 1004 No cells found 5

Top