ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Logic and Loop Code (https://www.excelbanter.com/excel-programming/343229-logic-loop-code.html)

oscarooko[_4_]

Logic and Loop Code
 

Hello,
I have this code that is suppesed to grade some loans. Unfortunatelly
evrytime I run it, i receive a " *run time error 13 type Mismatch*" o
the lines that Disqualify loans based on State, city, or low FIC
scores.

Someone help me fix the problem. Any advice is welcome


Sub Oscar()
Dim LoanAmount As String
Dim grade As String
Dim FICO As String
Dim lien As String
Dim LTV As String
Dim DTI As String
Dim PropType As String

David

Logic and Loop Code
 
Hi,
It is hard to make comparisons with strings, why are they Dim that way?
--
David


"oscarooko" wrote:


Hello,
I have this code that is suppesed to grade some loans. Unfortunatelly,
evrytime I run it, i receive a " *run time error 13 type Mismatch*" on
the lines that Disqualify loans based on State, city, or low FICO
scores.

Someone help me fix the problem. Any advice is welcome


Sub Oscar()
Dim LoanAmount As String
Dim grade As String
Dim FICO As String
Dim lien As String
Dim LTV As String
Dim DTI As String
Dim PropType As String



All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com