field=2

Sub foobar() Dim SearchText As String SearchText = "*" & Range("B4").Value & "*" With ActiveSheet .AutoFilter Field:=2, Criteria1:=SearchText End With End Sub

I'm trying to filter, not sure why its not workig, I seem to always have an issue with the does not <>, there's a formula in that cell, but it shouldn't matter I wouldn't think. With ActiveSheet .AutoFilterMode = False With Range("a2:m2" & lRow) .AutoFilter...

Hi all, Hopefully someone can put me out of my misery, as I've hit a brick wall with this one! So here's the plan: Sheet1: Contains all the data, pasted in on a monthly basis Sheet2 (Mapping Table): Contains the words which I'll be using in my autofilters In future the names used in the...

Hello Friends, I am using a VBA code to filter record. Here is the code I would like to give a range (D1) in the Field:=2 part of the code instead of "a" Any help will be appreciated Regards, Humayun

Hi friends, I need a macro to auto filter and save the result as an image. Would you please help me? I found this code but it "prints" the result i need to save the result as an image. Sub Auto_Print_Lamp_PK() Dim noDupes As New Collection Dim rw As Long Dim itm As Variant...

I am trying to filter through multiple columns. Below is the code I am using, what am I doing wrong? Sub Filterindata() Range("B1").AutoFilter field:=2, Criteria1:="1001 - North America" Range("J262").AutoFilter field:=1, Criteria1:="Severance" End Sub