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