Return Row Number With Largest Value

I've a column that contains numerical values. In my vba code, I have to select a block of cells at a time and get the row which has the maximum value.
One lame approach I am doing is wasting another column that extracts the max from the block of cells using Excel's Max function, and then doing a iterative search in the numerical column to get the cell tht contains the max value, and from it get the row number

Is there a better way such tht i can avoid the looping?

so in a nutshell, i want to get the row number from a range of cells that contains the maximum value