I know the absolute offsets of the rows and columns in a seperate sheet and want to get the max of that range. For example:
=Max(CC, RR, cc, rr)
where all the parameters are numbers allowing me to define the range.
I know the absolute offsets of the rows and columns in a seperate sheet and want to get the max of that range. For example:
=Max(CC, RR, cc, rr)
where all the parameters are numbers allowing me to define the range.
Try:
Function mxinr(c1 As Long, r1 As Long, c2 As Long, r2 As Long) As Double
Dim r, rr As Range
Dim v As Double
Set r = Range(Cells(r1, c1), Cells(r2, c2))
v = Cells(r1, c1).Value
For Each rr In r
If rr.Value > v Then
v = rr.Value
End If
Next
mxinr = v
End Function
--
Gary''s Student
"excel12345" wrote:
>
> I know the absolute offsets of the rows and columns in a seperate sheet
> and want to get the max of that range. For example:
> =Max(CC, RR, cc, rr)
>
> where all the parameters are numbers allowing me to define the range.
>
>
> --
> excel12345
> ------------------------------------------------------------------------
> excel12345's Profile: http://www.excelforum.com/member.php...o&userid=31975
> View this thread: http://www.excelforum.com/showthread...hreadid=517016
>
>
Check out the OFFSET() function in XL Help.
In article <[email protected]>,
excel12345 <[email protected]>
wrote:
> I know the absolute offsets of the rows and columns in a seperate sheet
> and want to get the max of that range. For example:
> =Max(CC, RR, cc, rr)
>
> where all the parameters are numbers allowing me to define the range.
=MAX(INDIRECT("Sheet2!"&ADDRESS(rrf,ccf)&"":""&ADDRESS(rrl,ccl)))
HTH
--
AP
"excel12345" <[email protected]> a
écrit dans le message de
news:[email protected]...
>
> I know the absolute offsets of the rows and columns in a seperate sheet
> and want to get the max of that range. For example:
> =Max(CC, RR, cc, rr)
>
> where all the parameters are numbers allowing me to define the range.
>
>
> --
> excel12345
> ------------------------------------------------------------------------
> excel12345's Profile:
http://www.excelforum.com/member.php...o&userid=31975
> View this thread: http://www.excelforum.com/showthread...hreadid=517016
>
Thanks to all of you for your help - I actually used a bit from each of you and solved the problem and learned some valuable information at the same time. Your time and effort in helping me is much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks