Tested again and the search on "scanned" produced not hits. I just realized that your code does not identify the column to be searched. I had
'CursorCol = Selection.Cells(1).ColumnIndex' in my original code that sets the column where the pointer is as the column to search, and 'For Each oCell In oTbl.Columns(CursorCol).Cells' to loop through that column. Now I don't know what the code you revised looks at.
|