+ Reply to Thread
Results 1 to 3 of 3

Runtime error 13 problem with a code

  1. #1
    Forum Contributor
    Join Date
    02-23-2015
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    109

    Runtime error 13 problem with a code

    Hello people I have made following code but It was a time ago...

    I get error: Runtime error 13 : incompatible types

    see code below

    Please Login or Register  to view this content.
    when I see troubleshoots the problem the error is:
    myTot = Round(DivAB / mycellRes)
    Could someone help me ?

    Thank you in advance

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Runtime error 13 problem with a code

    Hi -

    Please try to debug the codes and look for the values of;
    mycellRes
    DivAB

    they should be numbers

    event

  3. #3
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Runtime error 13 problem with a code

    Hi there,

    That error will occur if the value in cell "Cells(I, "AB")" is non-numeric.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

+ 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. Problem with VBA code - runtime error 1004
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2015, 02:22 AM
  2. [SOLVED] Runtime error 9 - can't find the problem
    By Ottoman079 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2013, 09:13 AM
  3. [SOLVED] Getting a runtime error with this code
    By rinser in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2013, 10:22 AM
  4. [SOLVED] VBA Code Problem (Excel 2010):Runtime error 424
    By aelgadi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-28-2012, 09:40 AM
  5. [SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004
    By charizzardd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 03:34 PM
  6. 1004 Runtime error problem
    By jp001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2009, 03:23 AM
  7. runtime error 9 problem with this code
    By cuewoz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2006, 09:54 AM

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