Reading the row number with VBA

[johan@durban]

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.

[Norman Jones]

Hi Johan,

Show your UDF code.

More generally, use the Row property which returns the (first) row number of
the range.


---
Regards,
Norman



"johan@durban" <johandurban.27l1zy_1147249800.9799@excelforum-nospam.com>
wrote in message
news:johandurban.27l1zy_1147249800.9799@excelforum-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
>

[Ivan Raiminius]

Hi Johan,

see help for caller property

Regards,
Ivan

[aidan.heritage@virgin.net]

Not sure what your function does, but

Function gd()
gd = ActiveCell.row

End Function


returns the row number of the active cell at the time the value is
entered - possibly a little unsafe as for example you can't autofill it

[Ardus Petus]

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
>

[johan@durban]

Hi everyone
That was wonderful response in such a short time.
I am now exploring rather using a range but I am going to try this caller thing first.
Here is my code:

Please Login or Register  to view this content.

[paul.robinson@it-tallaght.ie]

Hi
Activecell.row will do it.

regards
Paul

[johan@durban]

Thank you everyone.
The caller property did it for me. I am also going to explore other ways (just for fun).
Activecell I am afraid does not do the right thing. It seems activecell only works for the cell that was clicked on.