+ Reply to Thread
Results 1 to 2 of 2

Run-time error 13 - Type mismatch, when deleting cells

  1. 11-17-2013, 12:40 PM #1
    Johny1
    Johny1 is offline
    Registered User
    Join Date
    02-03-2009
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    30

    Run-time error 13 - Type mismatch, when deleting cells

    Hi All

    I found this code on the internet

    Please Login or Register  to view this content.
    It works fine but when delete any selection of cells in a row error 13 appears.

    Any ideas?

    Thanks
    Reply With QuoteRegister To Reply
  2. 11-17-2013, 02:01 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Run-time error 13 - Type mismatch, when deleting cells

    The code will only work if the Target range just contains one cell and therefore contains one value. Try this alternative.

    Please Login or Register  to view this content.
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Run-time error 13 - type mismatch when deleting data from multiple cells at once
    By missnk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 08:38 PM
  2. [SOLVED] Clearing cells within an Array - Run-time error 13 (Type mismatch)
    By Wobbigone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 01:37 AM
  3. [SOLVED] VBA Excel 2007 : Autofit Merge Cells Error "Run-time error '13': Type Mismatch"
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 04:10 PM
  4. type mismatch error when deleting cells
    By thigham2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2008, 05:04 PM
  5. Type Mismatch Error when deleting a cell
    By Josiah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2008, 01:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1