Please post the fixed code, beacause i whant to se the correct code.

Best regards:

willie


aking1987 Wrote:
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.

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