Run-Time Error '13' Type Mismatch

Excel Help for Run-time Error '13' Type Mismatch in Excel Multiple Regression Analysis and Forecasting Template

Run-time Error '13' Type Mismatch

Rate this: (2.2/5 from 4 votes)

	I read the previous post in the forum to check data type when this occurs. All of the data is clearly numerical and should not be the problem. I am working with about 14,000 observarations and keep getting this error. Is it because there are to many observations? There is no difference in the number of observations per variable so this is also not the problem. Please let me know how to fix this.
	Posted by Payers24 on 08 Aug 2006

Replies - Displaying 11 to 13 of 13

Order Replies By: Most Recent | Chronological | Highest Rated

	No data for one or more independent variables Rate this: (3/5 from 1 vote) After some testing, we came across a similar error when one or more independent variables have no data.  If titles are entered for independent variables, the program assumes that data exists beneath it. It then attempts look for empty or non-numeric input to exclude before running the analysis.  Since no data exists, it continues this process all the way to the last row of the worksheet. We have updated the download version to check for missing variable data in order to resolve this issue.
	Excel Business Forums Administrator
	Posted by Excel Helper on 13 Mar 2010

	Run-Time Error '13' Type Mismatch Rate this: (3/5 from 1 vote) I am getting this error in a small batch of data (six independent variables, one dependent, sample size of 4), even though I have entered the data by hand as numbers.  I have tried confirming that the data in all cells is in number format by highlighting, then bringing up 'format cells' and formatting all as 'numbers.'  Nothing was copied and pasted.  Any ideas?  Could it relate somehow to the small sample size?
	Steve
	Posted by edxmd on 13 Dec 2007

Run-Time Error '13' Type Mismatch" Rate this: (3/5 from 1 vote) I am also getting a Run-Time Error '13' Type Mismatch in my code. I wrote a code that swops a name into reverse Like accounts to untsacco. When do for one cell the code works perfectly but I need to select a range from A1:A200. When I do that thats when i get the mismatch Error, Please assist, here is my code Sub Macro1() Dim strPassword, Part1, Part2, Part3 As String Dim xPos As String Dim xLen As Integer ' Range("A1").Select strPassword = Range("A1").Value xLen = Len(strPassword) xPos = xLen / 2 If xLen Mod 2 <> 1 Then Part1 = Mid(strPassword, xPos + 1, xPos) Part2 = "" Part3 = Mid(strPassword, 1, xPos) Else Part1 = Mid(strPassword, xPos + 2, xPos) Part2 = Mid(strPassword, xPos + 1, 1) Part3 = Mid(strPassword, 1, xPos) End If outstring = Part1 + Part2 + Part3 Range("D1") = outstring End Sub

Posted by Hillary on 09 Sep 2009

Back

Displaying page 2 of 2