View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
 
Posts: 130
Default 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