Vba to Filter data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Vba to Filter data

FAQ

Thread Tools

Display Modes

05-28-2015, 10:00 PM

NoSparks

Windows 7 64bit Vba to Filter data

Office 2010 32bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Try this

Code:

Sub DeSelect_SomeThing()
    Dim filt As String
filt = "*" & Sheets("Sheet2").Cells(2, 2).Text & Sheets("Sheet2").Cells(2, 3).Text & "*"
With Sheets("Sheet1")
    .AutoFilterMode = False
    With .UsedRange
        .AutoFilter field:=1, Criteria1:="<>" & filt, Operator:=xlFilterValues
    End With
End With
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation list filter with range defined by OFFSET	Mango123	Excel	4	03-18-2014 02:52 PM
Mail merge with filter using data inputted by user	Tornado70	Mail Merge	6	04-09-2013 07:16 AM
is it possible, filter data come in a2, b2 cell	gsrikanth	Excel	1	07-05-2012 04:08 PM
filter	kwlickt	Excel	1	03-28-2011 11:15 AM
could you help me help me with advanced filter	Nora	Excel	1	05-15-2009 11:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:01 PM.