VBA/Macro for Excel 2016 - Excel AutoFilter Multiple Numbers Using VBA Macro

If you have multiple numbers to filter in a column and the numbers have no pattern then Excel's Filter Search Box or Number Filters won't be able to accomplish this task. You can use the following VBA Macro for accomplishing that:

Just edit the Range and Values of Array as per ur need:

	Sub Excel_AutoFilter_Multiple_Numbers_Using_VBA_Macro()
	'
	' Excel AutoFilter Multiple Numbers Using VBA Macro
	' Purpose: The purpose of this VBA Macro is to Filter Multiple Numbers from a Column
	' Date: 20160525
	' Author: Nauman Khan
	' Contact: http://naumankhan.blogspot.com
	'
	ActiveSheet.Range("$A$1:$A$100").AutoFilter Field:=1, _
	Criteria1:=Array("1", "5", "7", "10"), _
	Operator:=xlFilterValues
	End Sub

view raw Module1.bas hosted with ❤ by GitHub

To understand the syntax you can refer to:

Range.AutoFilter Method (Excel) http://msdn.microsoft.com/en-us/library/office/ff19… View Now

urShadoww/Excel-AutoFilter-Multiple-Numbers-Using-VBA-Macro Excel-AutoFilter-Multiple-Numbers-Using-VBA-Macro - The purpose of this VBA Macro is to Filter Multiple Numbers from a Column http://github.com/urShadoww/Excel-AutoFilter-Multip… View Now

Nauman Khan's answer to I have multiple numbers to filter in excel is it possible to type all numbers at once in excel filter search box? - Quora http://www.quora.com/I-have-multiple-numbers-to-fil… View Now

-urShadow


Reference: http://stackoverflow.com/questions/21834701/use-autofilter-on-more-than-2-criteria

• Next Tourist Visa for Muslims to Visit Saudi Arabia
• Previous Is it possible to embed HTML and JavaScript in answers or posts on Quora? - Quora