run time error 13

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...

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...

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 =...

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 =...

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...

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...

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...