+ Reply to Thread
Results 1 to 7 of 7

Copying listrow throws an error (copy method of range class failed) why?

  1. 05-26-2019, 07:12 AM #1
    LIL2606
    LIL2606 is offline
    Forum Contributor
    Join Date
    08-29-2017
    Location
    London England
    MS-Off Ver
    2016
    Posts
    194

    Copying listrow throws an error (copy method of range class failed) why?

    Hi all,

    I have the following code: 

    Please Login or Register  to view this content.
    Which is supposed to copy the row (my active cell is in) from the first table to the second, exactly as it is. The second table is the exact copy of the first under a different name and it's databodyrange deleted. I do have formulas in the last 3 columns (sum formulas to sum a range from the same row like: "=SUM([@[a column]:[another column]])") I don't know if they are the trouble makers.. I just don't know why this won't work....

    Please help!

    Posted on Mr.ExcelMessageBoard, as well Link: https://www.mrexcel.com/forum/excel-...ml#post5283615
    Last edited by LIL2606; 05-26-2019 at 09:04 AM.
    Reply With QuoteRegister To Reply
  2. 05-26-2019, 08:58 AM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Copying listrow throws an error (copy method of range class failed) why?

    Hi !

    Check the value of CopyRownr …
    Reply With QuoteRegister To Reply
  3. 05-26-2019, 09:00 AM #3
    LIL2606
    LIL2606 is offline
    Forum Contributor
    Join Date
    08-29-2017
    Location
    London England
    MS-Off Ver
    2016
    Posts
    194

    Re: Copying listrow throws an error (copy method of range class failed) why?

    Hey, I did and it seems correct. Just for debugging I added a 

    Please Login or Register  to view this content.
    And it looks at the correct row (the one I'm trying to copy)
    Reply With QuoteRegister To Reply
  4. 05-26-2019, 09:04 AM #4
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Copying listrow throws an error (copy method of range class failed) why?

    • First create a new row in the destination table.
    • Then copy the source ListRow to the destination ListRow as CopyRow seems useless …
    Reply With QuoteRegister To Reply
  5. 05-26-2019, 09:09 AM #5
    LIL2606
    LIL2606 is offline
    Forum Contributor
    Join Date
    08-29-2017
    Location
    London England
    MS-Off Ver
    2016
    Posts
    194

    Re: Copying listrow throws an error (copy method of range class failed) why?

    This throws the same error, I just tried it

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-26-2019, 09:25 AM #6
    LIL2606
    LIL2606 is offline
    Forum Contributor
    Join Date
    08-29-2017
    Location
    London England
    MS-Off Ver
    2016
    Posts
    194

    Re: Copying listrow throws an error (copy method of range class failed) why?

    Got it!! 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-26-2019, 09:32 AM #7
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Copying listrow throws an error (copy method of range class failed) why?


    Well done ‼
    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. getting error : select method of range class failed
    By clammastak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2015, 05:08 PM
  2. [SOLVED] Insert Row throws error "Insert Method of Range class failed"
    By bg_enigma1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 11:30 AM
  3. [SOLVED] Select method of range class failed error
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-07-2012, 10:13 AM
  4. DataSeries method of Range class failed error
    By kmoore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2011, 01:02 PM
  5. [SOLVED] [SOLVED] Excel 97 error: 'Copy method of range class failed'
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-07-2009, 05:59 AM
  6. Error - copy method of range class failed
    By Zygoid in forum Excel General
    Replies: 1
    Last Post: 10-24-2007, 04:28 AM
  7. Copy method of worksheet class failed - loop copying worksheets
    By lif in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2006, 05:02 PM

Tags for this Thread

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