select cell + moving up.

[ced0802]

Hi everyone,

I am stuck at progressing on my macro.
2 tabs on my spreadsheet "Analys" + "Data"

The macro below allows me to find the Max value in a list of data.
I would need now to associate this "Max" value to the title of the column that contains this Max value.

So basically the macro would select the max value, then would go up to pick the name of the column.

Thank you in advance. Hope it makes sense.

Please Login or Register  to view this content.

[LeoTaxi]

you know the rownumber of Columnheaders so

Please Login or Register  to view this content.

cheers
Leo

[ced0802]

Thanks Leo for your feedback.

However I am not searching to have a msgbox. I basically want to have my MAX value selected.

Thanks a lot for your help.

[LeoTaxi]

i read this

then would go up to pick the name of the column.

you can change the msgbox to any sheet and range you want

cheers
Leo

[ced0802]

Ok got you.

However here, it is giving me the name of first column in my range - my max is not necessary in the first column..

I would like this basically :

Please Login or Register  to view this content.

But not working. I m searching here the column number of my MAX value.
Thanks

[LeoTaxi]

Maybe something wrong with your loop, witch you dont need

try like this, change the red items, range to real range with values, and real row number with column headers

Please Login or Register  to view this content.

Cheers
Leo

[ced0802]

Thanks again Leo,

I get the following error on "myheader" line :

"Run time error 91.
Object variable or with block variable not set"

[LeoTaxi]

Please Login or Register  to view this content.

this must do it

Cheers
Leo

[LeoTaxi]

made a file with the sheetnames and this code

Please Login or Register  to view this content.

kind regards
Leo