VBA programming-autofilter function
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 |
VBA programming-autofilter function
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 "ylchuah" wrote in message ... 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 |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com