Actually your original code seems fine, providing the active (selected) cell
is K2, thereafter everything is relative. In your OP you say when you select
K2 the CF formula refers to T2, that would imply when the CF was applied A2
was active which seems odd looking at your code.

in your adjacent post
what do the "False" arguments actually do?

They return relative address without the $'s

Msgbox activecell.address & vbcr & activecell.address(false,false)

Regards,
Peter T

"Keith Wilby" wrote in message
...
"Peter T" <peter_t@discussions wrote in message
...
With your relative addressing everything is relative to the active cell,
try
changing -
).Address(False, False)
to
).Address


Hi Peter, I spoke too soon as all of the cells in the range now reference
row 2.