Is it what you need?
?ActiveCell.row
or
ActiveCell.Offset(rowOffset, columnOffset).Activate
>Hi all,
>
>I posted a similar question to an Office Dev forum and got no reply. I guess nobody was home.
>
>Anyway, this is an excel question but I was hoping someone knows how to do this. How do I automatically update a value based on the current cell without using macro.
>
>Example:
> A1 (R1C1) = 100
> B1 (R2C1) = 200
>
>Formula in E1
> = offset(currentRow,0,0,1)
>