runtime 13 error

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

Some videos you may like

This Week's Hot Topics

Top