Library issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with several modules in it to do different tasks. It was
written in Excel 2003 and it works great in Excel 2003 and Excel XP.

Unfortunately most of the users use Excel 2000 and when the try to do a
simple sort by running one of the modules attached to a button the sheet they
get the error message "Compile error: Can't find Project Library" I had a
look at the code and the first thing it has a problem with is the line:

Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

The error is with the xlSortNormal

How can I resolve this problem?
 
Just remove that argument...

Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
 
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
Simple Do... Until problem 4
Sorting Macro Loop 2
Simplfying the Sort macro 2
Sort issue 5
Sort error? 2
Writing a Sort Macro 4
Variable not Defined Error for Sorting Excel: 2000 2

Back
Top