+ Reply to Thread
Results 1 to 4 of 4

Range Cut & Paste Mismatch Error

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

    Range Cut & Paste Mismatch Error

    Thank you in advance for any help.

    I am getting a mismatch error when I am trying to define a range with lastrow. This code is meant to 1. Search for the word "True" in Column P 2. If "True" is found then copy columns A:O from the active row that "True" was found on 4. Delete that range only and shift cells up 5. Paste the range to the first blank row on another sheet. I have added an example workbook to this post for clarity.


    This line seems to be giving me the Mismatch Error
    Please Login or Register  to view this content.
    and this most likely
    Please Login or Register  to view this content.
    I thought I defined the range properly and then referenced the rng & lastrow in the area I am trying to cut. I am just not sure what I am doing wrong. Here is the code:

    Please Login or Register  to view this content.
    Thank you again for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Range Cut & Paste Mismatch Error

    Try...
    Please Login or Register  to view this content.

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

    Re: Range Cut & Paste Mismatch Error

    This works perfectly and is exactly what I was needing. I didnt even think to try to build that up from an intersect reference. Thank you for your help.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Range Cut & Paste Mismatch Error

    Glad to do it. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Put image in userform from Copy/Paste - Mismatch error
    By Ched_B in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2017, 10:03 AM
  2. 'Run-time error '13', 'Type mismatch' in Range value
    By jak68 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 02-16-2016, 04:14 AM
  3. Type Mismatch error with a range value
    By Coleman34 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2015, 09:02 AM
  4. .Range.Value Type Mismatch Error
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2014, 10:27 AM
  5. Range and Find function error: Type Mismatch
    By VBNewb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 02:10 PM
  6. Replies: 5
    Last Post: 07-27-2010, 10:58 AM
  7. Type Mismatch error & subscript out of range error
    By Jeff Wright in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2005, 03:06 PM

Tags for this Thread

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