hi Matt,

Here's another thread with a similar request that should help out (see
my other links in the 4th post of the thread):
'VB - Copy all rows with certain criteria - Excel Help Forum'
(http://tinyurl.com/lbu479)

In one of the links various options are shown for looping (or not)
through multiple criteria.

--------------
I recommend using "Option Explicit" at the top of your modules to
prevent any undeclared variables being created. Also, for the sake of
clarity, I recommend changing your undeclared "count" variable to
something else such as "cll" because "count" is a word with a recognised
meaning (as a property?) in Excel's VBA. You've shown it's use as a
property in your code where you use "rows.count".

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106115