Run Time error 438 "Object doesn't support this property or method"

[Hibbster]

Would anybody know why an excel macro would work for some users but not for others.

It works no problem for 95% of users (including myself) but the other 5% get the Run Time Error.

To be clear everyone is using the same spreadsheet from the same location.

I've stepped into the macro for a user who was getting the error and it errors on a sort command:

ActiveWorkbook.Worksheets("DATA").Sort.SortFields.Add2 Key:=Range _
("AH6:AH155"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal

Many thanks

 

[Norie]

Are they all using the same version of Excel?

 

[Fluff]

Try changing Add2 to Add

 

[Hibbster]

No, some are on 32 bit and some are on 64 bit. Also updates will be at different stages.

 

[Norie]

Have you tried Fluff's suggestion?

I had a similar problem - somehow in some code I'd written for sorting Add had been changed to Add2.

 

[Hibbster]

Thanks all. Yes, I have tried Fluff's suggestion and it still works fine for me.

Just waiting to hear back from the 3 field staff who are having the problem.

Will let you know.

 

[Hibbster]

Thanks Fluff. Works perfectly.

A simple solution which I would never have thought of

 

[Fluff]

You're welcome & thanks for the feedback