+ Reply to Thread
Results 1 to 6 of 6

Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

  1. #1
    Registered User
    Join Date
    08-25-2014
    Location
    New York, New York
    MS-Off Ver
    Excel 2013
    Posts
    36

    Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

    I have the following code below in a specific Sheet (A1) and if I copy and paste values in this sheet I get a Runtime error - Type Mismatch.

    Can anyone help?

    Please Login or Register  to view this content.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

    When you DEBUG, exactly which line of code is highlighted?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    08-25-2014
    Location
    New York, New York
    MS-Off Ver
    Excel 2013
    Posts
    36

    Re: Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

    Please Login or Register  to view this content.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,596

    Re: Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

    When you get the error have you copy/pasted multiple cells/rows/columns?
    If posting code please use code tags, see here.

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

    If you've pasted more than one cell, that code would be problematic. You need to add the ability for the code to "loop" through all the multiple pasted cells that intersect your watch range, like so:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    08-25-2014
    Location
    New York, New York
    MS-Off Ver
    Excel 2013
    Posts
    36

    Re: Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

    It is giving me an error still based on the entire code above. Can you show me how to change the entire code listed above.

+ 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. Runtime error 13 - type mismatch
    By Polluz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2014, 11:30 PM
  2. Runtime error 1004 when copying & pasting data to another sheet
    By luneke1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2014, 06:04 PM
  3. Type Mismatch Runtime Error
    By Jaeger in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-21-2014, 10:49 AM
  4. Runtime Error Type Mismatch
    By hungryhobo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2013, 08:50 PM
  5. Runtime Error 13 Type Mismatch
    By vtsoldier2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2012, 12:59 PM

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