tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
Am I correct in saying using an Advanced Filter in VBA automatically creates a named range called Extract?
I have the following:
and after running it, I see a named range.
I have the following:
Code:
MyRng.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=CriteriaRng, CopyToRange:=OutputRng
and after running it, I see a named range.