How to meet conditions with wildcards...

Hi everyone,

I'm trying to come up with a simple condition for a "String" value (Well, it's really in a Range but...).

My condition would starts with Activities but wildcard after at then end ( i.e. "Activities*" ) and this argument works fine with say .Find but doesn't seem to work in a condition.

My Sheet kind'of looks like: (sorry for the lame example)

ItemName...........Value 1..........Value 2
ActivitiesOne......1.....................5
ActivitiesTwo......2.....................4
ActivitiesThree...4.....................9
ProductOne........1.....................1
ProductTwo........2.....................3
ProductThree.....4....................10
Other123.............1.....................2
Other456.............3.....................2
Other788.............45...................233
etc...

My Code

' I've got a bunch of code before/after (it's in a loop) but my problem is this condition:
' Nota: rng is a Range (but rng shows the first column, which is String)

If rng = "Activities*" Or rng = "Product*" Then
'Do This
Else
'Do That
End If

' While debuggin, I've noticed that my wildcard * just isn't working. Any suggestions?

Thanks..

Alex

You could have a look at using the Like Operator and maybe the Select Case Statement.

Dom

Perhaps something like this...

Please Login or Register  to view this content.

Is that something you can work with?