Turn on the macro recorder and then set your filter manually.

Now turn off the macro recorder and look at the recorded code. This will
show you how to do it with VBA. Debra's site also has VBA examples.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Thanks for yur response. But i wanted to do the filtering operation
through VBA macro. so that the process can be automated.