Workbook.UseWholeCellCriteria (Excel)

True if the workbook uses search patterns that match the entire content of a cell.

Dim booUseWholeCellCriteria As Boolean
booUseWholeCellCriteria = ActiveWorkbook.UseWholeCellCriteria