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

Top