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.
Bookmarks