try creating a command button and assign macro
or copy the code under <view code.



"cjjoo" wrote in message
...

a macro will record all the actions that i have taken. Is that rite?

so for "apply advanced filter" , i have to goto record new macro

these are the steps that i took

data
filter
advanced filter

a popup will appear

and i have to define the list range follow by the criteria range

stop recording..

but once i run the macro from a text box (assign macro), there is an
error.

i dont know if these are the rite steps to take.

ANy recommendations?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=465795