Sub test()

MsgBox ActiveCell.Row

End Sub

RBS


"Bob Taylor" wrote in message
...
I am writing a general function and I would like to know what row the
function was excuted from, so that I can place that value in
Cells(row,col).value I have not been to find a behavior that will do this.
can anyone help

thanks
Bob