Finding the address of the cell that houses the maximum value in a column range

Hello all,

• I have a values in Cell (I15:I50)
• I want to know the cell address of the cell that has MAX(I15:I50) in my vba code

On my excel-sheet I wrote

Please Login or Register  to view this content.

What I need ?
How can i get to make my VBA code to display the address of the cell that houses the maximum value in the range I15:I50 ?

I tried :

Please Login or Register  to view this content.

This portion of the code "rng = WorksheetFunction.Application.ADDRESS(MATCH(MAX(I:I),I:I,0),9)" is in red and I am unable to understand why


another code I tried

Please Login or Register  to view this content.

gives me a run-time error-91 saying "Object Variable or With Block variable not set"