I had another great expert help me with this one, but I know they are too busy and I don't want to bug them on this one.
Why isn't this code working?
I have two kinds of codes being entered by a user:
DD-03-A ......AND...... DD03A
Why isn't this VBA working?
ElseIf nColScan = 10 Then
'151208 s4p remove hypens
If Len(sValue) < 5 Then
sValue = Trim(Replace(sValue, "-", "")) 'remove hypens, trim leading and trailing spaces
If Len(sValue) <= 7 Then
nRowNext = nRowScan + nRowDataSkip