locate max value in variable range
Application.Max(Selection)
But you probably don't need to select it.
Set rng = Range("M" & RCnt & ":" & "M" & EndRow)
MsgBox Application.Max(rng)
Alan Beban
john wrote:
After identifying the variable range and selecting it, how
can the maximum value be isolated for use in subsequent
step?
Variable range looks like this:
Range("M" & RCnt & ":" & "M" & EndRow).Select
|