runtime 13 error

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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