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 |
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 |