How can I get current cell row number

[excelneophyte]

I need to reference the row value of the current cell

 

[Rowan Drummond]

in a worksheet function: = row()
in VBA: activecell.row

Hope this helps
Rowan