VBA programming-autofilter function

[ylchuah]

Hi,

I have 2 worksheet=> A & B
I want to filter data in worksheet A, which the criterial is the value
in certain cell in worksheet B.

I have try the below method to filter a column which contain only "0" &
"1"
Selection.AutoFilter Field:=7, Criteria1:="0"
it work..

but when i use the same command which i change the criterial to some
text, then error happen.

And i found some syntax like
Filter(sourcesrray, match[, include[, compare]])
but i dun understand the line of syntax..

pls help...

Thanks
YL Chuah

 

[Norman Jones]

Hi Ylchuah,

I want to filter data in worksheet A, which the criterial is the value
in certain cell in worksheet B.
[cut]

but when i use the same command which i change the criterial to some
text, then error happen.

Using a text value on a second sheet as a criterion for an autofilter on a
first sheet, the following worked for me:

Public Sub Tester02A()
Dim DataSh As Worksheet
Dim CritSh As Worksheet

With ActiveWorkbook
Set DataSh = .Sheets("Sheet1")
Set CritSh = .Sheets("Sheet2")
End With

DataSh.ShowAllData

DataSh.Cells.AutoFilter _
Field:=7, _
Criteria1:=">" & CritSh.Range("A1").Value

End Sub


---
Regards,
Norman

Hi,

I have 2 worksheet=> A & B
I want to filter data in worksheet A, which the criterial is the value
in certain cell in worksheet B.

I have try the below method to filter a column which contain only "0" &
"1"
Selection.AutoFilter Field:=7, Criteria1:="0"
it work..

but when i use the same command which i change the criterial to some
text, then error happen.

And i found some syntax like
Filter(sourcesrray, match[, include[, compare]])
but i dun understand the line of syntax..

pls help...

Thanks
YL Chuah