I am looping through some rows of data, and I am getting an error on the following line.
PatternBasedFinishToUse = WorksheetFunction.VLookup(SurfCH_ValueAndSurfCH_FixedValue, Range("PatternBasedFinTable"), 2, 0)
How could I trap this error? Considered checking the chars it is returning... needs to be > 3 chars. If not >3 make the whole row background color red and put the word ERROR in col A. then move on to the next row. I use the Goto 100 which is a marker that starts the loop over. I know it is wrg to use Goto but have not had time to fit it to make it right.. It works for me...
Also considered and On Error Resume Next??? Any idea's