+ Reply to Thread
Results 1 to 4 of 4

Copy ActiveRow to another sheet

  1. #1
    Forum Contributor
    Join Date
    05-01-2018
    Location
    Maine
    MS-Off Ver
    2010
    Posts
    112

    Copy ActiveRow to another sheet

    Hello,

    I am trying to form a VBA code that will copy a row to another sheet if text appears in a cell. I keep getting object error when I try to run the code. Im not sure why as I thought if I 'Set' the sheets it would work for something like activerow.copy? I think that is where I am running into issues.

    This code should: 1. Search column K in "Dashboard" for an X 2. if X is found then copy the row to sheet "Archive" in the first blank row. I tried writing this code from scratch so I am open to figuring out where exactly I am going wrong.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,263

    Re: Copy ActiveRow to another sheet

    Try:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    05-01-2018
    Location
    Maine
    MS-Off Ver
    2010
    Posts
    112

    Re: Copy ActiveRow to another sheet

    Thank you. That did resolve the issue but I actually ran into another one. To keep up with the forum rules I posted the question in another thread: https://www.excelforum.com/excel-pro...ml#post5531049

    Kudos though as your solution worked but then I noticed other issues now that it is working.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,263

    Re: Copy ActiveRow to another sheet

    You're welcome. Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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] Delete certain columns in activerow
    By jamief in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2019, 08:42 PM
  2. VBA Code to ClearContents of multiple cells on an ActiveRow
    By Jalica in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2017, 02:20 PM
  3. Copy ActiveRow cells to another sheet
    By lynyrdskynyrd5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2017, 06:50 AM
  4. Change column by cell value in ActiveRow
    By stanley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2014, 01:20 AM
  5. [SOLVED] Macro to Highlight ActiveRow w/ DoubleClick
    By Kehoth01 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-23-2014, 11:37 AM
  6. Replies: 1
    Last Post: 01-17-2013, 05:27 PM
  7. VBA Copy activerow to another sheet
    By ronvannost in forum Excel General
    Replies: 1
    Last Post: 05-12-2010, 12:46 AM

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