S
Steve
Howdie all.
I'm using an auto filter that I received from here a last year and I want to
modify it to extract a name from a worksheet, and then set a filter criteria
from that worksheet's name.
I.e.,
fname = ActiveSheet.Name
fname = Right(fname, 7)
mv2 = fname
If LCase(fname) Like "????" Then 'not sure what to do here for my test.
Sheets(wks.Name).Range("A15:g15").AutoFilter field:=2,
Criteria1:=mv2 'this is to take into account the claim number
End If
The other elements oy my filter work great.
My worksheet- wks.Name- has a column with 3 to 7 digit values.
I need to compare the name of the fname to the values in that column--
field:=2
Any ideas on how I could do this?
I'm using an auto filter that I received from here a last year and I want to
modify it to extract a name from a worksheet, and then set a filter criteria
from that worksheet's name.
I.e.,
fname = ActiveSheet.Name
fname = Right(fname, 7)
mv2 = fname
If LCase(fname) Like "????" Then 'not sure what to do here for my test.
Sheets(wks.Name).Range("A15:g15").AutoFilter field:=2,
Criteria1:=mv2 'this is to take into account the claim number
End If
The other elements oy my filter work great.
My worksheet- wks.Name- has a column with 3 to 7 digit values.
I need to compare the name of the fname to the values in that column--
field:=2
Any ideas on how I could do this?