I am setting a specific range (A1:F29) and need to determine if a cell
contains a specific string, "CV7". This string an extension/suffix of a
larger string. If the string in the cell exists I would like to copy the
value of the cell and place it in a separate worksheet, worksheet 2. If the
string does not exist we should move on to the next cell within the range.

I am not sure how to sniff out the specific string.

Thanks,