Tom Ogilvy Wrote:
It is unclear who you are responding to, but if you are responding t
me, I
used neither of those constructs. The code I posted will work.


sorry, i was unclear:

I copied and pasted your code and got "object variable or with bloc
variable not set". I figured you meant to add in f = Filter so I adde
that as the third line, but then it errored for "argument not optional"

--
lcorey
-----------------------------------------------------------------------
lcoreyl's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=26232