Max function in VBA

[Zboy]

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?

[TonyS]

Hi,
Use

WorksheetFunction.Max(Your Range)

Tony

[Zboy]

i tried that it didn't work.

I typed in

maxnum = WorksheetFunction.Max(A2 : A22)

i need the maximum value for A2 to A22.

[TonyS]

Hi,
Try this

maxnum = WorksheetFunction.Max(Range("A2:A22"))

Tony