See Excel help on the OFFSET function

--
Biff
Microsoft Excel MVP


"JFA" wrote in message
...
I am trying to create a formula in a given cell that would refer to a
variable cell depending on the row number of the current active cell in
the
worksheet. How do I do that?
Many thanks in advance,