View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnUK JohnUK is offline
external usenet poster
 
Posts: 173
Default Lost from memory

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