you can have two macros
1. to do advnacae filter
2. remove this filter
number 2 is some sort of ;undo of 1
for both use record macaro button
"cjjoo" wrote in
message ...
I want to record a macro for advanced filtering . Is that possible?
the scenario: i want a box named "remove filter" and a box named "apply
filter".
The apply fiter is based on a criteria with a list on the same
worksheet.
Can anyone help me with this?
--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=465795