Hello all,

I am running this simple formula:
=INDEX(C2:C16,MATCH(TRUE,INDEX(C2:C16> 10,0),))

But i would like to make a VBA that select the cell where the answer was found instead of writing the answer in a new cell.

I am looking to find the first value over 10 in a column and select it. It is very important to select to cell for my macro to work.

Can anyone help me please, i have been looking for an answer for hours but i am stomped.

Thank you in advance