Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
sort function to sort for bell curve | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Error only on some machines ... VBA Sort function | Excel Programming |