Identify current active cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
Sorry, For some reason I thought you meant in VBA.
You already have a correct answer
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I display text when a cell value is 0 for accounting? 2
Creating a reader bar with Conditional Formatting 1
"if" cell = "X" then move it's row to another sheet 2
Identifying Current Cell 8
copying cell to a range 2
VB script for Current time 2
Date Formulas & format 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top