Identify current active cell

I would like to use the row & column of the currnet active cell pointed at by
the cursor. How do I get to get this info?
Thanks
Rod

Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" <reades@discussions.microsoft.com> wrote in message
news:C8A9672C-1785-4132-BBA4-6723D62E6585@microsoft.com...
>I would like to use the row & column of the currnet active cell pointed at
>by
> the cursor. How do I get to get this info?
> Thanks
> Rod

To get the row/column of the cell in which you're entering a formula, use
=row() or =column(). Note that the column will come back as a number (1
instead of A, etc).

"reades" wrote:

> I would like to use the row & column of the currnet active cell pointed at by
> the cursor. How do I get to get this info?
> Thanks
> Rod

Sorry, For some reason I thought you meant in VBA.
You already have a correct answer

--
Kind regards,

Niek Otten

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:OU$ht709FHA.912@TK2MSFTNGP11.phx.gbl...
> Activecell.Row and Activell.Column
>
> --
> Kind regards,
>
> Niek Otten
>
> "reades" <reades@discussions.microsoft.com> wrote in message
> news:C8A9672C-1785-4132-BBA4-6723D62E6585@microsoft.com...
>>I would like to use the row & column of the currnet active cell pointed at
>>by
>> the cursor. How do I get to get this info?
>> Thanks
>> Rod
>
>

Thanks, but this is not quite what I want. If I clik the cursor in a random
cell, say G7, then "G7" will appear in the name box in the top left corner.
How do I get hold of "G7" I use the contents of this cell?


"Niek Otten" wrote:

> Sorry, For some reason I thought you meant in VBA.
> You already have a correct answer
>
> --
> Kind regards,
>
> Niek Otten
>
> "Niek Otten" <nicolaus@xs4all.nl> wrote in message
> news:OU$ht709FHA.912@TK2MSFTNGP11.phx.gbl...
> > Activecell.Row and Activell.Column
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> > "reades" <reades@discussions.microsoft.com> wrote in message
> > news:C8A9672C-1785-4132-BBA4-6723D62E6585@microsoft.com...
> >>I would like to use the row & column of the currnet active cell pointed at
> >>by
> >> the cursor. How do I get to get this info?
> >> Thanks
> >> Rod
> >
> >
>
>
>

Where do you want the "G7" to go?

--
Kind regards,

Niek Otten

"reades" <reades@discussions.microsoft.com> wrote in message
news:8EF15AD2-FC69-4599-A0AE-3739CC0E5284@microsoft.com...
> Thanks, but this is not quite what I want. If I clik the cursor in a
> random
> cell, say G7, then "G7" will appear in the name box in the top left
> corner.
> How do I get hold of "G7" I use the contents of this cell?
>
>
> "Niek Otten" wrote:
>
>> Sorry, For some reason I thought you meant in VBA.
>> You already have a correct answer
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "Niek Otten" <nicolaus@xs4all.nl> wrote in message
>> news:OU$ht709FHA.912@TK2MSFTNGP11.phx.gbl...
>> > Activecell.Row and Activell.Column
>> >
>> > --
>> > Kind regards,
>> >
>> > Niek Otten
>> >
>> > "reades" <reades@discussions.microsoft.com> wrote in message
>> > news:C8A9672C-1785-4132-BBA4-6723D62E6585@microsoft.com...
>> >>I would like to use the row & column of the currnet active cell pointed
>> >>at
>> >>by
>> >> the cursor. How do I get to get this info?
>> >> Thanks
>> >> Rod
>> >
>> >
>>
>>
>>

i am trying find the same thing - is there a solution?

"Niek Otten" wrote:

> Where do you want the "G7" to go?
>
> --
> Kind regards,
>
> Niek Otten
>
> "reades" <reades@discussions.microsoft.com> wrote in message
> news:8EF15AD2-FC69-4599-A0AE-3739CC0E5284@microsoft.com...
> > Thanks, but this is not quite what I want. If I clik the cursor in a
> > random
> > cell, say G7, then "G7" will appear in the name box in the top left
> > corner.
> > How do I get hold of "G7" I use the contents of this cell?
> >
> >
> > "Niek Otten" wrote:
> >
> >> Sorry, For some reason I thought you meant in VBA.
> >> You already have a correct answer
> >>
> >> --
> >> Kind regards,
> >>
> >> Niek Otten
> >>
> >> "Niek Otten" <nicolaus@xs4all.nl> wrote in message
> >> news:OU$ht709FHA.912@TK2MSFTNGP11.phx.gbl...
> >> > Activecell.Row and Activell.Column
> >> >
> >> > --
> >> > Kind regards,
> >> >
> >> > Niek Otten
> >> >
> >> > "reades" <reades@discussions.microsoft.com> wrote in message
> >> > news:C8A9672C-1785-4132-BBA4-6723D62E6585@microsoft.com...
> >> >>I would like to use the row & column of the currnet active cell pointed
> >> >>at
> >> >>by
> >> >> the cursor. How do I get to get this info?
> >> >> Thanks
> >> >> Rod
> >> >
> >> >
> >>
> >>
> >>
>
>
>