+ Reply to Thread
Results 1 to 9 of 9

Copy Cells and paste to the bottom of the list in another workbook

  1. 01-19-2014, 01:02 PM #1
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Copy Cells and paste to the bottom of the list in another workbook

    I've got an issue with the code I have in the 'Save Schedule' button.

    When I execute the code and copy cells A22:G421 it pastes the values in to A2 of the new file and not the file I have opened "Running Ball Trading Records".

    Anyone tell me where I am going wrong?

    Thanks,
    Adam.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-19-2014, 01:54 PM #2
    xlbiznes
    xlbiznes is offline
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Copy Cells and paste to the bottom of the list in another workbook

    try changing this line of code ,

    from :

    Please Login or Register  to view this content.
    to:

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *
    Reply With QuoteRegister To Reply
  3. 01-19-2014, 02:19 PM #3
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Copy Cells and paste to the bottom of the list in another workbook

    I'm getting an error now saying Object doesn't support this Object or Method'.
    Reply With QuoteRegister To Reply
  4. 01-19-2014, 03:12 PM #4
    xlbiznes
    xlbiznes is offline
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Copy Cells and paste to the bottom of the list in another workbook

    sorry, that should have been activesheet , please change activeworkbook into activesheet.
    Reply With QuoteRegister To Reply
  5. 01-20-2014, 09:38 AM #5
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Copy Cells and paste to the bottom of the list in another workbook

    Thanks, that has done the trick.

    Can I just throw one last question in. How do I change this piece of code... 
    Please Login or Register  to view this content.
    So that it paste in to the next available blank row in column A as opposed to to constantly pasting in to A2.
    Reply With QuoteRegister To Reply
  6. 01-20-2014, 10:02 AM #6
    xlbiznes
    xlbiznes is offline
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Copy Cells and paste to the bottom of the list in another workbook

    sure,

    change this 
    Please Login or Register  to view this content.
    to


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-20-2014, 12:29 PM #7
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Copy Cells and paste to the bottom of the list in another workbook

    I've made that change but I'm now getting...

    Run-time error '1004'
    Application-defined or object defined error
    What does this mean?
    Reply With QuoteRegister To Reply
  8. 01-20-2014, 12:29 PM #8
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Copy Cells and paste to the bottom of the list in another workbook

    When I click debug it is referring to the last piece of code you gave me
    Reply With QuoteRegister To Reply
  9. 01-20-2014, 12:58 PM #9
    xlbiznes
    xlbiznes is offline
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Copy Cells and paste to the bottom of the list in another workbook

    try this instead

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help needed VBA Copy select cells and add to bottom of list.
    By thequiff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2013, 07:54 AM
  2. [SOLVED] Copy Specific Cells Across all worksheets in a Workbook and Paste Into single New Workbook
    By thunt13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 10:43 AM
  3. Copy/Paste Cells from old list to new master list by matching values
    By rfsmith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2012, 05:32 PM
  4. Code to copy data from one column and paste in at the bottom of another list
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2011, 10:20 PM
  5. Copy and paste non consecutive cells and paste consecutively in another workbook
    By macquhele in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2011, 02:36 PM

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1