Hi all I have a very quick question here. I have this code as attached to auto filter the data by the criteria in the code. However it can only run the filtering when the data is in the same workbook as this code.
There must be somewhere in the code that I can change to make it applicable to other workbook right? Please enlighten me, thank you very much!
Hi,
In the same way as you have set up a sheet variable (albeit always the ActiveSheet), you need to create a workbook Variable, e.g
wbMyBook as Workbook.
Then fully reference the range to be filtered. Something like.
wbMyBook.Sheets(oWS.Name).UsedRange.AutoFilter Field:=4, Criteria1:=arCriteria(index), Operator:=xlFilterValues
Note you'll also need to include the array index in the arCriteria variable
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks