Hi,

I have a sheet with measurement data.
The first row contains the headers waith the parameter name.
I have to look to a specific data from one parameter and find the data from
another parameter in the same row.
Unfortunately the order of the parameters is not always the same.

I want to solve this by searching for the first parameter (stapp) and set a
variable (col_stapp) equal to the letter of the column of that parameter.
I tried the following code:
Dim col_stapp as String
Cells.find(What:="stapp", After:=ActiveCell, LookIn:=xlValue,
LookAt:=xlWhole, SearchOrder:=xlByRows, SearcgDirection:=xlNext,
MatchCase:=False).Activate
col_stapp = Cells.Column

But I always get for col_stapp the value 1.

Whats wrong and how can I solve this?

Thanks for your help,

Gerrit