+ Reply to Thread
Results 1 to 3 of 3

Bug: Global Failure? Copy paste ontop if matches criteria

  1. #1
    Registered User
    Join Date
    08-08-2010
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    85

    Bug: Global Failure? Copy paste ontop if matches criteria

    Hi!
    Writing a code to copy a line from one tab to another. IF the audit# on PeerReview tab = to the PRCheckCell on the PRHistory tab, then I want the range to copy ontop (starting at the PRCheckCell....

    If they are different, it can past into the next line.

    My code is bugging out (see red below) and not sure why... ???

    Any suggestions?
    cheers!


    Please Login or Register  to view this content.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,260

    Re: Bug: Global Failure? Copy paste ontop if matches criteria

    Do you have more than 655 rows of data on your sheet?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    08-08-2010
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    85

    Cool Re: Bug: Global Failure? Copy paste ontop if matches criteria

    Hi Marvin,

    No I don't... and I won't have that many lines either... I just thought that it would be faster than going right to the end and up 65,000....

    :-)

+ 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