Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DHGranstrand
- Order by date
-
Using Named Range as Criteria in Autofilter
I want to use the named range as the criteria for the autofilter. ActiveSheet.Range(Selection.End(xlToRight), Selection.End(xlDown)).Autofilter Field:=1, _ Criteria1:=a1, Operator:=xlFilterValues- DHGranstrand
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using Named Range as Criteria in Autofilter
I am trying to autofilter a report that has a variable number of lines month to month to display only certain employees data. I have a named range ("ShowNames") that I want Autofilter to use as the filter values. The report is emailed to me monthly so I run the macro from a second Excel...- DHGranstrand
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
