Macro created in Excel 2002, getting runtime error in 2000

[amandarose80]

I'm not sure if this is a version issue or something to do with the settings.
I created a spreadsheet using Excel 2002 that has macros to run certain filters. These work fine in 2000. But when the other user goes to use the macro to remove all filters and sort the data by a specified column, she gets a runtime error. Anyone got any ideas of where to start to resolve this? Thanks!!

 

[Bowers74]

Could you show us your code please? Or at least explain what type of error is happening?

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[amandarose80]

We are at different offices but we are using the exact same file and are pulling it from the same place. I am not able to duplicate the runtime error... below is the code:

Sub RemoveFilters()
Sheets("Log Book&quot.Select
Selection.AutoFilter
Cells.Select
Selection.Sort Key1:=Range("E2&quot, Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("A2&quot.Select
End Sub