runtime 13 error

  1. B

    ReDim Runtime Error 13- Mismatch

    Hi all, I've pieced together the below code from other forums to achieve something I thought would be relatively simple, but it has thrown up an error which I'm not capable of solving. I have two ranges B44:E58 and H44:K58- products are listed starting at B44 with various details in the...
  2. N

    Error when I delete content in multiple cells simultaneously

    As I'm new to VBA I have tried following code which is working perfectly unless and until I delete some content in multiple cells of column B simultaneously. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then If Target.Value = "Shares" Then Target.Offset(0, 1).Value =...
  3. P

    Encountering Runtime Error When Entering Date in Textbox

    I have the following code that upon exit from Textbox87 first checks to make sure the user input a date in the correct format and that it is a valid date. Then it checks to see if it is a past date or a future date. I receive a Runtime Error 13 Type Mismatch error only if a nonsensical date...
  4. E

    VBA - Runtime Error 13 on simple macro

    Hello. I am using the following code to search for any cells that contain " " within a set range, and then clear the contents of those cells. I get a Type Mismatch (Run-time Error 13) and the debug highlights that the If cell.Value = " " Then part. It does seem to work on cells it look at...
  5. M

    Run Time Error 13 type Mismatch in Pivot table

    Hi, I have created a Pivot Create Code which worked Correctly. But Now the Data i am trying to use the code is of high columns and rows. Is there any solution on correcting this code. which must work in larger data too. Sub EGPivotCreate(DataSourceSheetName As String, DataSourceAddress As...
  6. T

    Excel VBA Run-time error '13"

    Hi, I created a macro, and when I run it i getting the runtime error 13 Type mismatch. I'm relatively new, so hopefully it will be an Easy solution. The idea of this part of the macro is to let the user open another excel file and copy the testsheet to the active workbook. The runtime error...
  7. A

    Type mismatch (Error 13) in Visual Basic while retrieving data from spread sheet 2010

    Hi, I am getting <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym> Run-time error '13' - Type Mismatch -...
  8. F

    Runtime Error 13 Type Mismatch from Macro

    Hi everyone, I am quite stuck in troubleshooting my macro to fix a runtime error 13 Type mismatch problem. Below are pertinent excerpts from my code: Dim HHYear As Variant Dim HAccount As Variant Dim HAmpersan As Variance HAmpersan = Chr(38) Cells.Find(What:="HPVAL", After:=ActiveCell...
  9. melewie

    Application InputBox Cancel/Wrong text entered problems

    Hi All, I am having some problems with application input box's, I'm trying to use them as a way to enter a password before the user is allowed access to a sheet, the code below is what I have, this works if the user enters the right password and if the user hits the cancel...
  10. D

    Runtime Error 13 Type Mismatch

    Hello, I'm using Excel 2013. I was running the macro below to trim all excess spaces out of cells. The macro was running fine until today. Now, I get the Runtime Error 13 Type Mismatch. I'm not sure why. Is there a more reliable code you could recommend? Thanks. Sub TrimXcessSpaces() 'On Error...
  11. A

    VBA Code showing runtime error '13'

    I was tasked with fixing this macro that isn't working but I don't know a lot about setting variables Here is the code Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target = [BF2386] Then If Target.Value = "Review Completed" Then Mail_small_Text_Outlook End If...
  12. K

    VBA Survey Issues, Mismatch 13 Error Code

    Hello! I am super new to creating VBAs in Excel and in fact this is my first attempt. I am trying to create a survey and what happens is when someone leaves a spot blank when they submit the survey then a Message Box will populate advising that need to go back to that question and fill in the...
  13. M

    Excel VBA Runtime Error 13 - Type Mismatch

    Hi all, I have a VBA script which is designed to conditional format certain cells based on another cells dropdown selection however every time i run it i get the runtime 13 error. Now i know the formula is a big one within this macro however i've been told this is the only way I can get excel...
  14. K

    runtime error 13 type mismatch in nested If statement

    Hi, I am encountering a runtime error 13 on the first If statement on the following code -- it seems to run through the loop and then produces the error midway through. I haven't been able to find a solution.. still newish at vba so would be grateful for any suggestions! Many thanks! Sub...
  15. M

    Type Mismatch error SQL query

    So I'm trying to copy databases over to another in order to revamp them. I'm having trouble with two different databases. Both are used to pull data from an existing table and the information is used to pull other data. You should note that the same code is used in the original database and is...
  16. C

    Need help with Type Mismatch Runtime error 13 on macro.

    I've getting a type mismatch runtime 13 error. Here's the code: Sheets("Data").Activate Dim u As Integer Dim na As String na = "#N/A" u = 2 Do If Cells(u, "W").Value = na Then MsgBox "test" End If u = u + 1 Loop Until Cells(u, "A").Value = "" The...
  17. D

    RunTime Error 13:'Type Mismatch' -again

    There are a number of posts on this and other forums regarding this error. I've now got this problem and I'm not even writing any code -per se. Two pcs: one runs XP home with office 2003, the other runs Vista 64 bit and Office 2007. In the Immediate Pane of VBA on XP/Excel 2003 typing (without...

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