I cannot get this to work:
[vba]
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) < 1 Then
[/vba]
Method of Range Failed
It has to do w/
[vba]Range(c.Offset(0, 55)).Value[/vba]
I can get this to work:
[vba]MsgBox Len(Range("BC6").Value)[/vba]
Posted Here originally:
http://www.mrexcel.com/board2/viewtopic.php?t=295928