DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,976
- Office Version
- 365
- Platform
- MacOS
I cannot get this to work-
However- this does:
Can you point out what is wrong for me in the first example please?
Posted here:
http://www.vbaexpress.com/forum/showthread.php?p=118251#post118251
Code:
If Not IsError(Application.Match(c.Value, Array("SNBD", "SNBB", "SNBT", "SNBJ", "SNBP", "SNBGG", "SNBH", "SNBGL", "SNBPK", "SHOES", "HAT", "BEAN", "TEE"), 0)) _
And Len(Range(c.Offset(0, 55)).Value & Range(c.Offset(0, 56)).Value & Range(c.Offset(0, 57)).Value) < 1 Then
However- this does:
Code:
MsgBox Len(Range("BC6").Value & Range("BD6").Value & Range("BE6").Value)
Can you point out what is wrong for me in the first example please?
Posted here:
http://www.vbaexpress.com/forum/showthread.php?p=118251#post118251