It doesn't work. Nothing gets pasted. I don't know if it's this
'ActiveCell.Offset(1, 0).Range("A1").Select' that is the proble
because it doesn't make sense to me.

I mentioned that the data at 'EnChData' was there. There are a lot o
macros before and after this one. I thought the error was probably i
this area because the data in 'EnChData' wasn't being pasted.

The clearing of the clipboard is something I hadn't considered whic
I'll look into, thanks.

I've been looking through a number of other threads and I've notice
the habit of many to post solutions but rarely any explainations. I
would be nice to have a tutor but at the moment I'm trying to learn VB
from practical exploration and PDF's. I've ordered a book to help bu
it's slow going

--
Damin
-----------------------------------------------------------------------
Daminc's Profile: http://www.excelforum.com/member.php...fo&userid=2707
View this thread: http://www.excelforum.com/showthread.php?threadid=46594