Cell formula that will give back the address of the cursor?

  • Thread starter Thread starter Byron
  • Start date Start date
B

Byron

There HAS to be a formula so that I need NOT go thru VBA to obtain the
current position of the cell pointer! Has to be! This CAN'T be new? Is
there anyway to access the 'Name Box"?
 
I don't think you can do this without a selection change event macro.

Simply selecting a cell does not trigger a calculation so a formula wouldn't
update.

This formula will return the active cell address but it will only update
when some event triggers a calculation.

=CELL("address")

Probably not what you had in mind!
 
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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Array formula lock-up 1
Using the return from ADDRESS within another formula? 5
Formula for average of cells that have blanks 1
Searching the formula (not the value) for a text string 1
Finding the weighted average of text that have been given values 1
Help With Formula For Cell Addresses 2
vba macro that allows insertion of symbols at cursor 0

Back
Top