Results 1 to 15 of 15

Thread: Copy and Paste Error between Application instances

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-15-2006, 12:51 PM #3
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base     VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    I thought I could explicity call out the new App instance and the current App instance in the copy portion of the code, but that didn't work either:

    ' Import
xlApp.Workbooks(xlWB.Name).Worksheets(xlSh.Name).Range(xlDataRange.Address(0, 0)).Copy _
Destination:=Application.Workbooks(wbData.Name).Worksheets(shData.Name).Range("A1")
    What's worse, is if I just leave out the Destination field and have it copy to the clipboard and paste (manually), instead of Pasting "A1:AG2,A3329:AG3575", it pastes "A1:AG3575" what gives?
    Last edited by Aussiebear; 04-16-2023 at 03:21 PM. Reason: Adjusted the code tags




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules