code to return max value in column and assign to variable

[bradyj7]

Hi all,

I'm looking for some code to look up the max value in column P (the number of rows in column P varies) and then assign this value to a variable called MaxTorque? Any ideas?

Thank you

 

[VoG]

Hi. Try

MaxTorque = WorksheetFunction.Max(Columns("P"))

 

[Jonmo1]

Try
MaxTorque = Application.Max(Range("A1", Cells(Rows.Count, "A").End(xlUp)))

 

[bradyj7]

Hi
Thanks jonmo1 thats worked. Thanks to VoG too.