If it is in any of these...
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.
|