List Header Rows Property

[Mike]

Thanks in advance for any help.

Is there a VBA function that will tell me the row number
of the active cell? For example, say that I am in cell
G149, this function would return the value 149.

I saw the List Header Rows Property in the Object Browser
but I'm not really sure if this will do the trick.

I am using Excel 2000. Thanks again.

Mike

[Chip Pearson]

Mike,

Use the Row property. E.g.,

Dim R As Long
R = ActiveCell.Row


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:101201c50faf$756601c0$a401280a@phx.gbl...
> Thanks in advance for any help.
>
> Is there a VBA function that will tell me the row number
> of the active cell? For example, say that I am in cell
> G149, this function would return the value 149.
>
> I saw the List Header Rows Property in the Object Browser
> but I'm not really sure if this will do the trick.
>
> I am using Excel 2000. Thanks again.
>
> Mike

[Tom Ogilvy]

ActiveCell.Row

--
Regards,
Tom Ogilvy


"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:101201c50faf$756601c0$a401280a@phx.gbl...
> Thanks in advance for any help.
>
> Is there a VBA function that will tell me the row number
> of the active cell? For example, say that I am in cell
> G149, this function would return the value 149.
>
> I saw the List Header Rows Property in the Object Browser
> but I'm not really sure if this will do the trick.
>
> I am using Excel 2000. Thanks again.
>
> Mike