Need help with complex IF/Then

[lbdyck]

Here is my code:


If Flag = 2 Then
flag2 = 1
If IsEmpty("A" & i) Then flag2 = 0
If Range("A" & i) = "STRING 1" Then flag2 = 0
If Range("A" & i) = "STRING 2" Then flag2 = 0
If Range("A" & i) = "STRING 3" Then flag2 = 0
If flag2 = 1 Then
Call Proc_Text(array, i)
End If
End If


Where i is the row number that i'm processing and array is where i will put the data in the subroutine.


I only want to call the Proc_Text routine if the tested conditions are not met.


The data is a csv of information and the values in each row could be different so i'm looking only for those rows that start with a date and avoid those that are blank or have descriptive text.


Thank you

 

[chicagocomputerclasses]

The correct syntax is

IF Condition THEN
'do something
ELSEIF Condition THEN
'do something
ELSEIF Condition THEN
'do something
ELSE
'do something
END IF


That being said I would look at SELECT CASE for this.

 

[lbdyck]

Thank you - the elseif was helpful as it forced me to rewrite and i found my challenge with the logic.