<div>
Try something like this:<br />
<br />
Public Function fnRangeMax(strRangeName As String)<br />
<br />
Set rg = Range(&quot;R_01&quot;)<br />
&nbsp; <br />
&nbsp;fnRangeMax = Application.Max(rg)<br />
&nbsp; &nbsp; &nbsp; <br />
End Function<br />
<br />
Flyster
</div>


Try something like this:

Public Function fnRangeMax(strRangeName As String)

Set rg = Range("R_01")
 
 fnRangeMax = Application.Max(rg)
     
End Function

Flyster

<div>
Can I also enter this a formula into a cell?<br />
<br />
=Max(Range(&quot;R_01&quot;))<br />
<br />
I tired this it didn't work. Any idea how this would work if possible at all?<br />
<br />
Mike
</div>


Can I also enter this a formula into a cell?

=Max(Range("R_01"))

I tired this it didn't work. Any idea how this would work if possible at all?

Mike

<div>
<div class="content wysiwyg-content">
There is a named-range (R_01) representing the following cells:<br />
<br />
Formulas!$D$1:$AA$2<br />
<br />
Question: How can I detect the max. value in this range?<br />
<br />
MsgBox fnRangeMax(&quot;R_01&quot;)<br />
<br />
Public Function fnRangeMax(strRangeName As String)<br />
<br />
&nbsp; &nbsp;fnRangeMax = &lt;how to look through this R_01 and return the max. value it has?&gt;<br />
End Function<br />
<br />
Thank you.
</div>
</div>


There is a named-range (R_01) representing the following cells:

Formulas!$D$1:$AA$2

Question: How can I detect the max. value in this range?

MsgBox fnRangeMax("R_01")

Public Function fnRangeMax(strRangeName As String)

   fnRangeMax = <how to look through this R_01 and return the max. value it has?>
End Function

Thank you.

return max. value from a range...

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.