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
>> >
>> >
>>
>>
>>