Max function in VBA

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?

Hi,
Use

Please Login or Register  to view this content.

Tony

i tried that it didn't work.

I typed in

Please Login or Register  to view this content.

i need the maximum value for A2 to A22.

Hi,
Try this

Please Login or Register  to view this content.

Tony