Not sure I understand. Maybe this will work:

INDIRECT("RC6",0)

It's relative to the row and the column is absolute.


--
Biff
Microsoft Excel MVP


"Alan Beban" wrote in message
...
I have the following question from a colleague:

I like to solve the following problem. I have an RC address in one cell of
the form, RC6, (current row, col 6). I like to copy and paste this to
another cell (or copy the conditional format portion involving a formula
of the above address form), but the address in the new place to reflect
its new row, that is, the address should remain as RC6 in the new place.
When I do the copy and paste, the row address changes to an absolute
address of the form R[-4]C6, which is the correct behaviour by the above
definition.

But if I start with a relative R[0]C6, the only form I know for a relative
row format, when copied it gets converted into an absolute RC6 at the new
place. Is there a way to get the effect I want, or is this a known bug
(ala feature as defined by MS) in Excel 2000 (9.0.2720)?

TIA,
Alan Beban