+ Reply to Thread
Results 1 to 4 of 4

Run-Time Error 13

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    40

    Run-Time Error 13

    I'm getting a "Run-Time Error 13" for the attached sheet and the following code.

    Please Login or Register  to view this content.



    My guess is that it is due to mixing a string with numbers but I'm not sure how to make the code work.

    Ultimately the strings in column E that contain TLP TAR MCL TLC and CPD should cause the amount in column H to be multiplied by 1.1 and entered in column J.

    Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by andresndor; 04-16-2019 at 11:57 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Run-Time Error 13

    You cannot right an if statement like that, try
    Please Login or Register  to view this content.
    Also please edit your post to include code tags.

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Run-Time Error 13

    Thank you Fluff13 it works exactly as intended.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Run-Time Error 13

    You're welcome & thanks for the feedback

+ 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] Error message: Run-Time error '1004 '; application-defined or object-defined error
    By Davasu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2015, 06:52 AM
  2. Replies: 1
    Last Post: 10-22-2015, 05:50 AM
  3. VBA ERROR: run time error 1004: Application-defined or Object-defined error in excel 2013
    By AnanthKrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 06:16 AM
  4. Cannot Publish Excel Pivot Chart - Run Time Error
    By crisb184 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 07:04 AM
  5. [SOLVED] Error " Run-time error '1004': application defined or object defined error
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 07:26 AM
  6. run-time error ;2147023179 (800706b5) time automation error interface unknown
    By karthik72 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 09:31 AM
  7. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 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