needing some If Range value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johnny Mick - 23 Mar 2006 20:28 GMT

Good afternoon ,
I'm lost . . .this bit of code is used in a 'call.' it works fine in the
body of the program, but does not work in any of my 'calls.' why??? I've
tried just about everything (except reboot). Still a rookie here, but I
can't seem to figure this out. Thanks in advance for any and all assistance.

For count = 3 To 1000
If Range("A" & count) = "Lanham" Then
If Range("H" & count) = "IX*" Then
figure = figure + 1
End If
End If
Next count

Reply to this Message

Johnny Mick - 23 Mar 2006 20:50 GMT

here's an example of the data the loop is 'counting' through:
A H
Lanham    CK082917
Lanham    CK082780
Lanham    PT204185
Lawyer    CK082960
Lawyer    RB01MZW-060A
Lawyer    RA01MZW-060A
Lawyer    PT204673
Lawyer    R01MRIC-060P

> Good afternoon ,
> I'm lost . . .this bit of code is used in a 'call.' it works fine in the
[quoted text clipped - 9 lines]
> End If
> Next count

Reply to this Message

Johnny Mick - 23 Mar 2006 22:37 GMT

I guess my trouble post was a little too vague. . . thanks anyway. . .I
figured it out. For some reason, I wasn't able to use '=' when comparing a
value with a wildcard. . .I ended up using 'Like' and it is working fine.

> Good afternoon ,
> I'm lost . . .this bit of code is used in a 'call.' it works fine in the
[quoted text clipped - 9 lines]
> End If
> Next count

Reply to this Message