run time error 13

  1. Y

    Dim as picture | Type mismatch | VBA

    Estimated forum members, I've created the following macro to generate an outlook email and turn ranges into pictures before pasting them in the mail's body. The thing is that from time to time (approx. 1 out of 5 attempts), it results in an error message 'Error 13, Type mismatch'. If said...
  2. A

    vba code in 365 gives error 13 in Excel 2007

    My Dear Learned Friends. Can any help be forthcoming with 2 problems I have. The first is that when the workbook is opened, no worksheet Tabs are visible. I have checked in the advanced section of the application, and tabs is selected. problem 2 follows The following code runs fine on "365" but...
  3. V

    I can't figure out this Run time Error 13 Type Mismatch

    My code is pretty simple in terms of what I am doing, but I get a mismatch error despite the variable being shown to equal one of my conditions. Code is below: Private Sub CoverBox_Change() Dim ptCvr As Variant Dim pkSize As Variant Dim ptCheck As Variant ptCheck =...
  4. W

    Runtime Error 13 in my code

    I am getting a run time error 13 in my code between the **. Can anyone out there see why? For some reason the code will run and do what I want, but then spit out the error. Any help will be appreciated. Sub Recon() Dim i As Integer finalrow =...
  5. D

    VBA Pivot Table - Run time error 13

    Hi Just copy the code from online for Pivot table filter base on Cell Reference. Its working fine f no ("blank") in filter. Its blanks its shows Error so i add this Code pf.PivotItems("(blank)").Visible = False Now i getting Run time error 13. Its Date filter base on cell Reference, Any one can...
  6. X

    Error when Inputbox is Canceled

    I have an input box set up to prompt the user to select a range of cells. When i select cancel and no data range was selected, i get a run-time error '13: type mismatch. Clicking on debug it refers me to my set calculated_range line of code. Not sure what i am doing wrong. The code works...
  7. J

    Macro to insert IF "A" or "B" Then Do "C" - Not Working (Run-time error 13: Type Mismatch)

    Any thoughts why my If .value = "A" or "B" then statement isn't working? Sub Remove_CorrNeg_Transaction_Entries() Dim Dest_Firstrow As Long Dim Dest_Lastrow As Long Dim lRow As Long Dim CalcMode As Long Dim ViewMode As Long With Application CalcMode =...
  8. J

    Loop through multiple sheets - Run-time error '13': Type mismatch

    Hello, I am receiving a "Run-time error '13': Type mismatch" when I adjusted my code to loop through all worksheets beginning with "Labor BOE" instead of just the specific worksheet I was working on. Does anyone have any thoughts on why this is occurring and how to fix it? The goal of the code...
  9. smide

    Run-time errors handling in VBA

    Hello. I need some assistance with my VBA code which extract numbers under certain conditions (every 2 minutes) to Sheet4 from data report in row 1 - Sheet5. I'm not very proficient with excel-vba but I'm open to suggestions and willing to learn to get this to work properly. Basically, my...
  10. A

    Run Time Error 13 when updating Data Source for OLEDB connection

    I wanted an easy way for a user to change the file path for an excel report that gets run every day. The workbook I'm building is bringing the data from that separate report into a worksheet via an OLEDB connected Table. To do so, I recorded a macro to change the location. Then I modified the...
  11. G

    VBA Run Time error 13 Type Mismatch

    Hi - I've got a work file where the following is occurring: When the VBA Project is locked, and I run a macro, I'm getting a VBA error "Run Time Error 13 Type Mismatch". I close down the file with out saving, re-open, unlock the VBA Prjoect and run the macro, it works fine. Anyone come...
  12. C

    Run Time Error 13 Issue

    Hi all I have been running a spreadsheet with a Macro for several weeks now, when all of a sudden, having changed nothing in the code, I start to get run time error 13 appear. I find the section of code causing it (which again has worked fine up until now), could not get it to work so...
  13. B

    Textbox change error

    I have a userfrom with 3 textboxs (textbox1, textbox2, textbox3). I want when the user input a number in text box 1 for textbox2 to = +7 more than textbox1's value and for textbox3 to = -7 less than textbox1's value. I have it working correctly except if there is a number that is typed in wrong...
  14. D

    Run-time error 13 Type Mismatch

    Thank you in advance for any help. I am getting a run-time error 13 type mismatch and can not figure it out. Below are the two macros I am running: Private Sub Worksheet_Change(ByVal Target As range) If Intersect(Target, range("D11:D34")) Is Nothing Then Exit Sub Else Call PartBalance...
  15. H

    run time error 13 type mismatch when clearing multiple cells

    Hello All - First time Poster here, name is Tim. I've been working on building an Excel document, when based on user input into a certain cell, prompts them for information and places received information in a cell. I have all that working to my liking, however, I'm getting stuck on a Run Tim...
  16. Y

    Run-Time Error 13 VBA

    Hi there. Not too sure what i can do to fix this coding, basically when the checkbox is checked, it adds one to a particular cell on another workbook. Sub CheckBox1_Click() strFirstFile = "C:\Users\owner\Desktop\Test Over WBK" strSecondFile = "C:\Users\owner\Desktop\Statistics Runpage" If...
  17. C

    Run time error 13 in an If Else

    Still new to VBA, and I'm on the verge of tearing my hair out. I'm running into a run time error 13 in my If Else statement. What I'm trying to do is run through data in column F "Product ID" of my sheet called "Raw Sales" and if the value is a 4 it uses a vlookup to look up value in column B (a...
  18. R

    run-time error '13' type mismatch

    Hello, I'm new at VBA and I could use some help debugging my code. I keep getting the error, "run-time error '13' type mismatch." Thanks. ' Converts 0.00 values to "-" characters '--------------------------------------- For Each c In...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back