+ Reply to Thread
Results 1 to 8 of 8

rows not copied to clipboard with COPY method

  1. #1
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    rows not copied to clipboard with COPY method

    sorry guys, simple question and I must be stupid, literally. here's what I have:
    Please Login or Register  to view this content.
    nothing is being copied from book to book in the above code. all objects are set just fine, all variables have the vals they need to have. I've tried everything I can think of to get the code to recognize I want the row data copied from one book and pasted in a row in another book. I've tried to activate anything I can think of. all of the following tricks I've tried, and nothing happens with these either (included in the below attempts is some code that I got from the macro recorder too, which doesn't make sense whatsoever):

    trying to activate the worksheets before copying
    Please Login or Register  to view this content.
    trying to activate the workBOOKS before copying
    Please Login or Register  to view this content.
    trying to SELECT the data before copying and before pasting
    Please Login or Register  to view this content.
    what in the world am I doing wrong here guys? I would think that one of these attempts would work!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: rows not copied to clipboard with COPY method

    rowEndOfData = wsDriverNew.Cells(.Rows.Count, 1).End(xlUp).Row
    Are you doing this inside a "with/end with" statement?

    Doubt it makes a difference, just noticed it.
    Last edited by davesexcel; 10-08-2020 at 11:33 AM.

  3. #3
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: rows not copied to clipboard with COPY method

    no i'm not. why would it matter?

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: rows not copied to clipboard with COPY method

    Do you have
    Please Login or Register  to view this content.
    in your code?
    If so get rid of it & then try running the code again.

  5. #5
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: rows not copied to clipboard with COPY method

    no i don't fluff. there is no error handler on purpose, for testing.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: rows not copied to clipboard with COPY method

    In that case what error message do you get & what line does it highlight.

  7. #7
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: rows not copied to clipboard with COPY method

    there is no error that occurs. the code runs right through and nothing happens.

  8. #8
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: rows not copied to clipboard with COPY method

    this has been magically solved, and I went through so many testing phases regarding opening, closing books, restarting windows, etc, etc....I don't even remember most of it. the following code is what ended up working 10 times in a row, so I went with it:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy selected Matched rows to clipboard
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-26-2018, 08:07 PM
  2. Clearing a copied Shape from the Clipboard with VBA?
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2016, 08:37 AM
  3. Replies: 3
    Last Post: 07-11-2015, 05:17 PM
  4. Bypass Clipboard when copy/pasting non-contiguous rows
    By mlj61289 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 03:11 PM
  5. Is it possible to paste the first item that you copied in the clipboard??
    By mageamida in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2012, 12:52 PM
  6. Replies: 3
    Last Post: 01-13-2012, 10:46 AM
  7. move rows without copy/paste clipboard
    By treyr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-22-2010, 12:11 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1