With the answer to the previous question:
I now need to determine the column number by finding the text in any cell on the active worksheet.
text = "Customer Mfgnumber Search"
If Cells(1, target.column) = "Customer Mfgnumber Search" then
' rest of your code
This will only look in row 1 so...I need to
Find the value in any cell on the workbook and then designate that column as the target column number