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


--
ylchuah
------------------------------------------------------------------------
ylchuah's Profile: http://www.excelforum.com/member.php...o&userid=25341
View this thread: http://www.excelforum.com/showthread...hreadid=388216