Hi,

I want my excel macro to search through the columns on a given row and if a
cell equals any of a set of values then make variablex that column.

So check Row 1 to see if any column has a value in this set: rate, level,
average.

If so make that column = variablex

I have most of it figured out. Really don't know how to create/use a set (or
something similar) in VBA.