Hi All,
I'm trying to filter and sort data in a table in another workbook using the following code:

Please Login or Register  to view this content.

If I don't activate the workbook, I get Run-time error '1004': Method 'Range' of object'_Global' failed.

However if I activate the workbook (no need to activate the sheet) then it works fine.

Do I have to activate the workbook to sort? I want to keep this workbook in the background ideally.