I need to determine the maximum value in a dynamic range. The values
(pressures) are in Column S. The starting row# is in cell Q5 and the ending
row number is in cell R5. I do not know how to specify the column and
associated row # when the row # is contained in a cell. I tried the
following and similar variations:

=Max("S" &"Q5" : "S" &"R5")

Everything that I have tried so far results in an error message.

Is there an online tutorial for learning how to specify column/row
references when the column and/or row # is contained in a cell? Thanks for
any help and pointers on this request. I am trying to learn Excel by trial
and error and it is taking awhile. From tips and responses on this website,
I have figured out how to use dynamic ranges (Offset command) for charting
series, queries for an SQL database, and macros. I've made a lot of headway
in recent weeks but I am still stumbling, often, on what may be the simpler
To Do things. Thanks for listening.