Thread: help with copying worksheet (excel 97 vs excel 2000)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
  
Posts: 789
Default help with copying worksheet (excel 97 vs excel 2000)
Hi
Try inserting
Application.CutCopymode = False

before the copy. This clears the clipboard (I think) and I remember it
fixing something similar for me.

regards
Paul

Reply With QuoteReply With Quote