Hi, I have found out what it is. Its because I have a DisplayStatus bar in
the code. Once disabled the copy worked fine
Many thanks anyway

"JohnUK" wrote:

Hi All,
I want to copy a part of one workbook to several others through programming,
but by the time the 1st workbook opens it has lost the copy from memory. If I
was to manualy copy first it works, but there is something that makes it lose
it once the program starts. I have taken out all the Application.CutCopyMode
= False just in case it had something to do with it. Is there something I can
insert into the code that will remember the copy?
Help appreciated. John