With your latest suggestions the clouds are starting to clear. I a
able to make this work now.

I am still curious as to why in the TestTarget worksheet if column A i
empty the copy works but keeps writing over itself in column B.
believe it has something to do with the way the CurrentRegion propert
works. Not having any rows or columns to use to detect a boundary are
I believe it is not able to increment past the row it has just written
In the current configuration I would need to save TestTarget durin
each loop. This would be too time consuming.

Your assitance has started me on the road to success. I have tried t
pull each line apart and understand what it is doing. My understandin
if VBA is growing. Thanks for investing your time in me.

Thank You for your kindness,

Crai

--
Craig
-----------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...fo&userid=2438
View this thread: http://www.excelforum.com/showthread.php?threadid=38020