Hi Angel

The criteria range is two cells, not one

Headername
*Yahoo*



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Angel" wrote in message ...
yes, I figured out how to do it in auto, but how do I advance filter with
"contains"?

"VBA Noob" wrote:


I assume this is using advance filter


Try

*YAHOO.COM*

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=573455