Finding the Max number

[emmcee]

Hello guy,

I'm suppose to find the PEAK_POWER (max number) from a list of unknown number of range of unknown numbers and let it store in a cell B17,

So far I got this, which works:

Sub PEAK_POWER()

Range("B17").Value = WorksheetFunction.Max(Range("F3:F34"))

End Sub

but Assume that I don't know the range of F3 to F34, How can I adjust that code so that when i do run it somewhere else it would work, assuming we don't know the range.

Thanks!

 

[Andrew Poulsom]

How would one determine the range to be used?

 

[VoG]

Try like this

Sub PEAK_POWER()
LR = Range("F" & Rows.Count).End(xlUp).Row
Range("B17").Value = WorksheetFunction.Max(Range("F3:F" & LR))
End Sub

 

[emmcee]

I'm not sure, I was told that there is a code the can be used for this so that any range used such as from A2 to A100 can still get an answer

 

[emmcee]

Thanks worked perfectly