Hello, I am trying to remove filter from WB1 Sheet3 and WB2 Sheet1. My code is as follows below. My issue here is I can't get WB2 to be activated to sort the data in WB2 Sheet1. My code brings me to WB1 Sheet1 instead. Thank you in advance.
Dim varSheetA As Variant
Dim varSheetB As Variant...