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.