Hi Tom

I run this and it looks like it is all working fine.

I turned screen updating on so that I could see it.

It seems to run and copy the row. But when it finishes..there i
nothing on sheet 3.

I am also a little concerned that it appears to be making actions i
rows 50000 + when the sheet only has 500 lines on it
any ideas ?

Thanks

Davi

--
DB10
-----------------------------------------------------------------------
DB100's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=27829