If it is in any of these...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Do you want each cell in the column to equal variablex? column = variblex is
illegal.
 
No, the macro is searching the column headers to find the right column.
However I want to use it on different files and each file has the "right"
column labelled differently. I just want to be able to find the right column
# and the right column being the one that has value a, b, c, d or e.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find a value in a sheet and replace it with another value if it matches 8
VBA set thick borders around non empty cells in range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
lastrow function help 6
Named cells in an array to a column and to a row 3
VBA CreateNames (ignores last 5 rows?) 6
Excel VBA 1
Transfer array element offset value to a matched value 3

Back
Top