problems with macros

[cjjoo]

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?

[R.VENKATARAMAN]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[cjjoo]

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?

[R.VENKATARAMAN]

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



"cjjoo" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>