Max value in macro

[Qroozn]

in my vba coding i have the results
sugar=12
bird=11
dog=57
(based on other calculations)
how can i write a formula to return the max value of these items? (i.e. 57)

 

[Colo]

Hi Try this.
Sub test()
Dim sugar, bird, dog
sugar = 12
bird = 11
dog = 57
MsgBox Application.WorksheetFunction.Max(Array(sugar, bird, dog))
End Sub