Tommy,
#1- Compile error:
For Each control variable mst be Variant or Object

My Goal is this-(restated for clarity)
Look for "Hat" or "Shoe" (We have this)
If finds either and value is in decimal format and is not a whole number then convert to fractional.

regards,