workbook.Sort.SortFields.Add2() method - different behaviors

[vba_php]

folks,

I have this code:

Please Login or Register  to view this content.

LR1 = 342 = last row of data. wsDrawings is a sheet inside a book, also defined to a var named wbDrawings. the code runs just fine for me with no errors. however someone in England, with a different ver of excel (not sure what ver), is getting an error here:

Please Login or Register  to view this content.

the error is: object doesn't support this property or method. the MS KB says nothing whatsoever: https://docs.microsoft.com/en-us/off...sortfields.add

an image of the sheet being sorted is below. anyone run into this before? what should I check?

[Fluff13]

You just need to change Add2 to Add

[vba_php]

I ran ADD in place of ADD2 and it worked fine. but then again, that's me. I will see what the person in the UK says. thanks.