mismatch error

Good Morning Everyone, I'm trying to use "match" to find a row value. I've been fighting with this for about 45 minutes and don't seem to be getting anywhere. Here is the code: ActiveWorkbook.Worksheets(1).Select Dim a As String, B As Range a = "MvT" Set B = Worksheets(1).Range(Cells(1, 3)...

Hi All, I face a "Type Mismatch" error with the code below, ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ Sheets("DONNEES").Range("A1").CurrentRegion, Version:=xlPivotTableVersion10).CreatePivotTable _ TableDestination:="Sheet1!R1C1", TableName:="PivotTable1"...

Hello, I'm writing a VBA program and receive "run-time error 13: type mismatch" In the code below the line in bold receives the error. <code> Let FactornEMA(nEMA) = 2 / (FactorMA(nEMA) + 1) 'run-time error 13: type mismatch Let Cells(1 + nData, colEMA(nEMA)) = FactornEMA(nEMA) *...

Hi everyone, From what I already read on this forum this is a very common error but the existent threads didn't help me though. This is the first time I'm programming in Excel/VBA and I'm doing something really simple. I need this for image processing: I have two columns with x and y...

I'm very new to VBA and I just wrote a macro (mostly modifying code I copied from these message boards) that seems to be working correctly, but I keep getting the Error 13 message. When I go to debug the line "If Sheets("MSTR").Range("AD" & i).Value = 1 Then" from below is highlighted. Any...

i keep getting error mismatch but i have ensure the table names and columns are the same could someone please help me: here is a piece of the code Dim Index As Sheets Set Index = Sheets Sheet1.Activate Dim Element As Worksheet Set Element = ActiveSheet Element.Activate SQL1 = "SELECT FROM " &...

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

System: Win XP Excel: 2003 I´m just learning how to write Macros. What I want to do is get the corresponding category for certain fields (Mnemonic) these fields are grouped by countries. The categories are on column 3, whereas the mnemonics are grouped by countries in the rest of the columns...

Hello All, I am experiencing a type mismatch error, and I'm completely stumped. In the code sample below, it's caused by the text in red. I've tested the values of the variables with statements like this, placed in advance, right above the error: Worksheets("Raw").Cells(13, 13).Value = Ends...

Morning All, I have a procedure that was working perfectly yesterday. I've not changed it and yet today it doesn't seem to be working. I keep getting a 'Runtime Error '13', Type Mismatch' debug error. Can you help? Public intRowCount As Integer Sub mcrCopyDataNewSheet() Dim...

Hello, I am having trouble trying to prevent this error from popping up and I was wondering if anyone could give me any clue as to why this is occurring. My code checks to see if a cell contains a certain status, such as Approved or Rejected. If the status is Approved, then the procedure...