I have fixed this code.

Thank you for your time any ways.

I do however have a new query...

numerous times i find myself having to type arm lengths of code whe
copying and pasting...

if cell A1 contains data then copy it to Sheet1 cell A1,

if cell a2 contains data then copy it to sheet1 cell A1 BUT ONLY IF a
is empty...

And so on... so you aquire a list rather than gaps.

--
aking198
-----------------------------------------------------------------------
aking1987's Profile: http://www.excelforum.com/member.php...fo&userid=1539
View this thread: http://www.excelforum.com/showthread.php?threadid=31479