使用1列值作为搜索数组

I have a code which searches for individual values across a whole workbook. the problem I have is that I need to type in all the codes I am searching for individually but the code selection is already contained in a single column on a worksheet within the workbook. Basically what I want the search to do is to look at the values in this column and use them as the array across the whole workbook.I have a code which searches for individual val