R
reades
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
the cursor. How do I get to get this info?
Thanks
Rod
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
Activecell.Row and Activell.Column
B
bpeltzer
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).
=row() or =column(). Note that the column will come back as a number (1
instead of A, etc).
N
Niek Otten
Sorry, For some reason I thought you meant in VBA.
You already have a correct answer
You already have a correct answer
R
reades
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?
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?
N
Niek Otten
Where do you want the "G7" to go?
J
John Carroll
i am trying find the same thing - is there a solution?