iRow = Application.Caller.Row

HTH
--
AP

"johan@durban" <johandurban.27l1zy_1147249800.9799@excelforum-nospam.com> a
écrit dans le message de news:
johandurban.27l1zy_1147249800.9799@e...rum-nospam.com...
>
> Hi Everyone
> I have a little UDF that will look for a value in a row and then return
> the value next to it.
> It works well but I need to supply the row number on which the function
> resides as an input parameter. There MUST be a way te read the row
> number automatically. Something like getrow() or whatever.
> Any sugestions would be appreciated.
>
>
> --
> johan@durban
> ------------------------------------------------------------------------
> johan@durban's Profile:
> http://www.excelforum.com/member.php...o&userid=34266
> View this thread: http://www.excelforum.com/showthread...hreadid=540570
>