ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   locate max value in variable range (https://www.excelbanter.com/excel-programming/274077-re-locate-max-value-variable-range.html)

Alan Beban[_3_]

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




All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com