run time error 13

  1. 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 =...
  2. 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...
  3. 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...
  4. 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 =...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top