Check out the OFFSET() function in XL Help.


In article ,
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.