+ Reply to Thread
Results 1 to 6 of 6

Code: Find, Copy, Paste not working

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    33

    Wink Code: Find, Copy, Paste not working

    Hi,
    I have a code that worked when it was looking for a blank cell in column A and pasting new user input(A1:F1) below the last populated cell there. It does not work, now that I have edited it to find a specific entry (L1 in column I:I) and copy the users input (A1:F1) and paste it in the same row - but 8 columns to the left.
    It selects the correct row, moves to -8 columns also, but then stops shy of pasting the content like it is suppose to.

    Any clues what I need to do to correct this?
    Thank you for your help





    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Code: Find, Copy, Paste not working

    Can you post a sample workbook?

  3. #3
    Registered User
    Join Date
    05-02-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Code: Find, Copy, Paste not working

    This is a draft version of my schedule for maintenence on their equipment, and it usually has many conditional formatting indicating due and overdue items etc. However, I had to remove most of the conditional formats and regular formats in the calendar and log pages otherwise the file was too large to attach.

    Thank you for having a look at this.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Code: Find, Copy, Paste not working

    In your example it's not finding the value in L1. It's best to test first if Find returns anything and then you can see where things are going wrong. E.g.
    Please Login or Register  to view this content.
    Last edited by StephenR; 06-26-2012 at 01:50 PM.

  5. #5
    Registered User
    Join Date
    05-02-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Code: Find, Copy, Paste not working

    It displays the message box "Not found" of course.
    Thinking that it does not like the formula which results in the rngDetailFound, I have made the rngDetailFound a value, and not the result of a formula. But it still can not find what is in L1 at all.
    Still searching for an answer
    Thank you for any help
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-02-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Code: Find, Copy, Paste not working

    This is all my fault for overlooking what L1 was giving me. I found that the combination that resulted in the value in L1 is actually not what it should have been. It should have been K3&L3 , not K3&H3 (H3 has the issue# attached to the end of the datecode)

    So all the codes actually worked. Sorry for not spotting this earlier.
    But thank you for giving me food for thought.

+ 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