Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code logic error [email protected] Excel Programming 1 September 4th 05 03:45 AM
How to Loop some code Phil Osman Excel Discussion (Misc queries) 2 August 19th 05 11:14 AM
How to get my code to loop Dominique Feteau[_2_] Excel Programming 5 December 17th 04 01:35 PM
Logic for a FOR loop Hari[_3_] Excel Programming 12 June 14th 04 11:27 PM
VBE code in a loop loloflores Excel Programming 0 April 30th 04 12:28 PM


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"