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 1 to 10 of 13

Order Replies By: Most recent | Chronological | Highest Rated

	New "Run-Time Error '13' Type Mismatch" Rate this: (3/5 from 1 vote) In Excel, on the taskbar, select the File tab, then left-click Open from the list provided. Now click on the required file and select Open -> Open and restore -> Restore (you can also select the Extract data tab). If everything goes well, runtime error 13 will not bother you again. Regards,Rachel Gomez
	rachel
	Posted by RachelGomez161999 on 09 Dec 2022

	Run time error 13 Rate this: (3/5 from 1 vote) I have just downloaded the trial software and tried running some numerical data for regression.  I am also having Run-time error 13.  All of my data is complete and numbers.  I tried formatting the numbers, pasting only data into cells. Restarting excel 2007.   Data is: SPrice SF BR FB HB TtlFl Garage Carport View Pool 249000, 2300, 3, 2, 0, 1, 2, 0, 1, 0 This program is exactly what I am looking for if I can get it to run correctly.
	John Patton
	Posted by aeroshare on 11 Sep 2011

Software Glitch Rate this: (3/5 from 1 vote) There is obviously a software glitch with Excel. I sometimes get the error and there are times I do not get the error running the same program with no changes. If I close the program and reopen it the problem remains. However, sometimes if I restart Excel it will correct the problem and the program will run OK for a while. Then all of a sudden I try to run the program again and "Run-Time Error '13' Type Mismatch". Aaaaargh!!! There is no type mismatch with the data. I checked and rechecked if there was some way I was mixing data types of had blank data. None!!! I've downloaded a fix from Microsoft for this problem but have had no luck installing the fix. I tried updating Windows XP to service pack 3, which is suppose to have the fix in it, but still get the error about 50% of the time. If anyone has found a solution to this software bug please let me know. Thanks in advance.

Posted by dalerhs on 30 Jun 2010

	Run-Time Error '13' Type Mismatch Rate this: (3/5 from 1 vote) Thanks. I'm not sure what solved it, as I downloaded the new version first, but I think it may have been as simple as that I was deleting the data in the third example column, but not the title for it.  Thanks again.
	Posted by jboyce on 13 Mar 2010

	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) Hi, Thanks for your help. No I haven't added columns or rows into the spreadsheet, just input the data. I have redownloaded the spreadsheet to check that I hadn't done it previously, and this is still the case.  Any more ideas? Thanks.
	Posted by jboyce on 12 Mar 2010

	Input data sheet layout Rate this: (3/5 from 1 vote) In this case, the program has attempted to correct non numerical or empty input cells.  If it has added zeros below the input data, then it has encountered a problem locating the input data.  Have you added rows or columns within the Input sheet?
	Excel Business Forums Administrator
	Posted by Excel Helper on 12 Mar 2010

Run-Time Error '13' Type Mismatch Rate this: (3/5 from 1 vote) Hi, I get this message too. I have tried adjusting the text / number format. I have tried copying and manually inputting the data. I have tried using just a few data values, and all of them (approx. 200) but to no avail. When I click run regression the computer takes ages to determine the run time message, and when I click end, it has changed the number of observations from its original value to 59997 after having put 0's in all the rows beyond the data. I can't understand why this might be happening. Please help. Thanks, Jack

Posted by jboyce on 12 Mar 2010

	Cell formats and values Rate this: (3/5 from 1 vote) Your code expects to find only strings (i.e. Text) in each cell.  You will get a "Run-time error '13' Type Mismatch" if any of the cells are either formatted differently (e.g. a number) or are empty. If I were you, I would define your target cell as Variant then check to see if it is actually a string in the cell before doing the transform.
	Excel Business Forums Administrator
	Posted by Excel Helper on 01 Oct 2009

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

Displaying page 1 of 2

Next