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 && active cell
>  B1 (R2C1) = 200
>
>Formula in E1
> = offset(currentRow,0,0,1) && how do I get currentRow to be equal to the activecell row.
>