Multiple like statements?
Hi T,
Sub TestIt()
If CAR.FAC_NO = HEAD.FAC_NO Then
If BALANCE.COMP = "NIL" Then
If BALANCE.Year = 2005 Then
If BALANCE.PER_NO = 99 Then
If BALANCE.ACCOUNT Like "5%" Then
If HEAD.AREA Like "333%" Then
If HEAD.AREA Like "666%" Then
If HEAD.AREA Like "999%" Then
'Your result code here
End If
End If
End If
End If
End If
End If
End If
End If
End Sub
Note, all single quotes changed to double quotes.
---
Regards,
Norman
wrote in message
ups.com...
Hello,
Is it possible to use more than one LIKE statment in an Excel Macro?
Here is what I have:
WHERE CAR.FAC_NO = HEAD.FAC_NO AND ((BALANCE.COMP='NIL') AND
(BALANCE.YEAR=2005) AND (BALANCE.PER_NO=99) AND (BALANCE.ACCOUNT Like
'5%') AND (HEAD.AREA like '333%'))
Which works...
But, I want to add more LIKE statments.
i.e. ....AND (HEAD.AREA like '666%') AND (HEAD.AREA like '999%'))
How ever I get errored out.
The LIKE statements grabs groups of number with a common beginning
three digits. But it seems I can only do it for only one set, number
multiple numbers.
Any suggestions?
Tmuld
|