VBA code to find maximum number

[emmcee]

heys I need help in writing a VBA code to find the maximum number in a range of numbers that are in one column from H4 to H34 and to put that answer into another cell say B17.

Any help/tips/advice would be greatly appreciated!
Thanks

 

[VoG]

Try

Sub test()
Range("B17").Value = WorksheetFunction.Max(Range("H4:H34"))
End Sub

 

[emmcee]

Thank You so much worked perfectly!