Hi,

I receive an Excel tab with headers. The header is always the same
exept for the order. I mean, let's say I have the header : Name , Unit,
Company
Those three will always be there but in different order.

Then, I'm trying to write a macro that will reference those column.
Since the order will change, I would like to be able to look in the
first row (headers) for the name of the column I'm looking for and
store the column number in a variable cons.

Can somebody help me with that? I have no idea how do it. I'm sure I
can, but how....

Thanks,

Kathy