Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming or Function? | Excel Discussion (Misc queries) | |||
WORKSHEET FUNCTION or PROGRAMMING. | Excel Worksheet Functions | |||
Programming a Function in VB | Excel Discussion (Misc queries) | |||
Simple Programming Function?? | Excel Programming | |||
Function tool or programming...Help please! | Excel Programming |