Hi

Don't know if there is a setting for this (doubt it) or if code can b
written, but one thing you could do is copy your list and go to a blan
worksheet and Paste Special/Transpose, and then AutoFilter on that

--
jette
-----------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...fo&userid=1753
View this thread: http://www.excelforum.com/showthread.php?threadid=55850