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

Identify current active cell
 

Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" wrote in message
...
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

Identify current active cell
 

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

Identify current active cell
 

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

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" wrote in message
...
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

Identify current active cell
 

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" wrote in message
...
Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" wrote in message
...
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

Identify current active cell
 

Where do you want the "G7" to go?

--
Kind regards,

Niek Otten

"reades" wrote in message
...
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" wrote in message
...
Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" wrote in message
...
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

Identify current active cell
 

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" wrote in message
...
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" wrote in message
...
Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" wrote in message
...
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