Select Case - Wildcard or other alternative?

northwolves

Well-known Member

Joined

Jun 21, 2006

Messages

1,128

Office Version

1. 365
2. 2019
3. 2016
4. 2013
5. 2010
6. 2007
7. 2003 or older

Platform

1. Windows

• Jan 23, 2009

• #2

[code[]]
Case Is >= "700", Is < "800"
[/code]

 

Upvote 0

X

XLML

Active Member

Joined

Aug 15, 2003

Messages

407

• Jan 23, 2009

• #3

Thanks for the response NorthWolves but that made everything outside that range, even the blanks say 'complete'. The column that those numbers are in Is Text, I don't know if that makes a difference.

Any advice?
Thanks,
XLML

 

Upvote 0

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Jan 23, 2009

• #4

XLML

This might be one case, pun intended, where case isn't suitable.

Or you need to take a different approach to is use.

For example only using the first character of the cell's value.

Whether or not that's appropriate depends on the other criteria, you've only posted one example - kind of hard to work with.

 

Upvote 0

mikerickson

MrExcel MVP

Joined

Jan 15, 2007

Messages

24,355

• Jan 23, 2009

• #5

Code:

Select Case Left(testString,1)
    Case Is = "7"
       Cells(cl.Row, "J") = "COMPLETE"
    Case Is = "6"
       Cells(cl.Row, "J") = "almost Complete"
End Select

 

Upvote 0

X

XLML

Active Member

Joined

Aug 15, 2003

Messages

407

• Jan 24, 2009

• #6

Thanks for the suggestions Norie and Mike. I ended up using Left to pull the first digit.

Thanks again,
XLML

 

Upvote 0