I'm trying to use the max function in VBA and trying to retrieve the value from the MAX function and use it in my Vb coding.

Can anyone help me with this?