+ Reply to Thread
Results 1 to 5 of 5

Copy paste on cell Change

  1. #1
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Copy paste on cell Change

    Hi everyone,

    I am trying to copy and paste an entire row onto another sheet, but I can't quite get it to work.

    I have a code that identifies if a change was made in Column M, and if the user changed it to "True."

    If so, I run a code module which takes the target, copies, and pastes into sheet. The problem is with Target.EntireRow.Select, because it doesn't know the target. Should I define the address of the target in the other code, or should I not be using target in the first place?

    Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Copy paste on cell Change

    Try this. Change your worksheet name from T1 to yours

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Copy paste on cell Change

    It doesn't like my paste function now. Whats a better paste code than selection.paste?

  4. #4
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Copy paste on cell Change

    Scratch that, but the rows keep posting on top of themselves. The row counter + 1 doesn't seem to work properly.

  5. #5
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Copy paste on cell Change

    Figured it out, I just needed a counter.

    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)

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