Thread: Copying and Pasting.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jared Jared is offline
external usenet poster
  
Posts: 109
Default Copying and Pasting.
I have to instances of excel. I want to copy from one instance of Excel and
Paste to another. I'm attempted the following code, which has worked fine
when working with one instances of excel. However, I get "object doesn't
support property or method " when trying it here.

Excel1.ThisWorkbook.Sheets(1).Cells(1, 1).Copy _
Excel2.ActiveWorkbook.ActiveSheet.Cells(1, 1)

Reply With QuoteReply With Quote