Macro for finding and copying the max value in a column

[2636warrend]

Hello, I am looking for a macro that will find the largest value in a column (e.g. C36:C101) and then copy that value into a new cell (e.g. D62). As I am very new to VBA any help would be appreciated.

 

[Rick Rothstein]

You are aware you can do what you asked for with a simple Excel formula in cell D62, correct?

=MAX(C36:C101)

Anyway, to answer your specific request...

Sub PutMaxFromC36C101toD62()
  Range("D62").Value = WorksheetFunction.Max(Range("C36:C101").Value)
End Sub