Another option
Instead of looping through each row
try Autofilter - Filter on "Closed" value
Copy, paste, delete
--
mudraker
If my reply has assisted or failed to assist you I welcome your
Feedback.
www.thecodecage.com
------------------------------------------------------------------------
mudraker's Profile:
http://www.thecodecage.com/forumz/member.php?userid=18
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=40121