error 13

I was just sent a new workbook with macros to use to track my numbers at my new job. This particular macro is used to combine all the different sheets into one master sheet. When I try to run it, i get runtime error 13:type mismatch. Here is the code from the debugger. The error is coming...

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

I have been developing a form to enter data into a spreadsheet, it has been working fine, i havent changed any code recently but i have started to get a runtime 13 mismatch error. This code is in a module that is called from the cmd button: Sub Button1_Click() Worksheets("Daily...

Hi! I created a macro for a file and first it was working fine, but today I've been oppening and restarting the file and macro hundreds of times and I'm allways guetting the following error: Excel VBA Run-time error '13' Type mismatch I didn't change anything in the macro so dont know why am I...

Hello, I'm developing a code that is suppose to convert the NumberFormatt of a number depending on it's unit (m3 or L) My code works for the most part but once I try to delete more than one cell at a time, the program crashes and a debugger window opens saying "run time error 13: Type...

Hi When I attempt to insert or delete a line from my worksheet, I get an Error 13 (Incompatible type I think would be the translation to english). This is an extract from the routine (which works perfectly well when I don't need to insert a line LOL): Private Sub Worksheet_Change(ByVal Target...

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

Everytime I run this code I get a "Run-time error '13': Type Mismatch" and I can't figure out why. Can anyone tell me what the error means and how to fix it? Thanks! Sub populateComboBox() Dim lr As Long With Sheets("Data Sheet") lr = BlankRow("Data Sheet", 2, 4)...

Hello! I have a macro that goes through the values in a certain range and replaces 'tokens' I've set up (e.g. +State+) with the corresponding value from the current records column. For all the instances where the new text is one or two words everything works beautifully. But for the tokens...

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

Hi, I am in the middle of testing my first attempt at using VBA code and to my dismay am running into difficulties. I have used the following VBA code in a For loop to check for empty cells in a spreadsheet: If Cells(i, 1).Value <> "" And Cells(i, 13).Value <> "" And Cells(i, 20).Value <> 0...

Userform has textboxes for input / output, as well as combobox1 & 2 to load data into form and sheet in background. I have been trying to program it so that the user can simply change the text box prices and costs, and it updates on the fly. It works perfectly with only with one input textbox...

Hi people, I have big, big problem and i need to fix it very fast. Every time i run user form and select value in combobox 4 i get run time error 13 type mismatch at part of code witch i will mark in code i post. Private Sub ComboBox4_Change() TextBox12.Text =...

The code below works but I want to substitute the variables in red for the literals in blue. I can see the correct numeric values being obtained by the red variables. Yet, as soon as I substitute the red variables, I get an error 13 - type mismatch. The values in red are always numerics and are...