+ Reply to Thread
Results 1 to 2 of 2

Runsheet with Macro Issues (Run-time Error '13': Type Mismatch)

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    1

    Runsheet with Macro Issues (Run-time Error '13': Type Mismatch)

    Hi There,

    First off I am new to using Macros....I am working on a runsheet for the producer of our Sports Show. I believe I have gotten the timing formulas correct. The macro used in the spreadsheet is so the producer doesn't need to enter in hh:mm:ss... (hence [m]:ss).

    What I need now is the ability to delete and add rows freely based on the amount of stories used per segment (it will vary for each episode) Each time I do this I get the Run-time Error '13': Mismatch

    Additionally I need the formula and formatting to be included in any new rows are inserted.

    runsheet-demo_forum.xlsm

    Thanks so much.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Runsheet with Macro Issues (Run-time Error '13': Type Mismatch)

    Because once you delete the row, the cell value become unknown. Maybe put an error handle procedure

    Please Login or Register  to view this content.

+ 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. [SOLVED] Macro Code - Run-time error'13':Type mismatch :(
    By pipsmultan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-27-2014, 04:34 AM
  2. Filing Macro - Run time error '13: Type Mismatch
    By WillJ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2014, 07:44 AM
  3. Re: Help with a macro- 'Run-Time error '13' Type Mismatch
    By pman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2012, 03:31 PM
  4. Macro gives Run-time error '13': Type mismatch, but nothing has changed?
    By BlondOIverBlue in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2010, 11:52 PM
  5. [SOLVED] Visual Basic macro run time error(13) type mismatch
    By Paul in forum Excel General
    Replies: 0
    Last Post: 10-25-2005, 03:05 AM

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