active cell address ?

B

Brian J

Hi,
i have a problem with getting Excel to display the current active cell address in another cell on the same worksheet.
Any help much appreciated.
 
J

Jim Rech

The formula would be:

=CELL("address")

Of course a calc is needed to update it after the cell selector is moved.
 

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

VBA Coding Help for Beginner 0
Generated text copies into another template 0
Cell data entering slow! 0
Active Content in this file is blocked issue 1
Newbie Help - IF Yes No Function 0
Dynamic Naming of Form Button 3
Cell Alignment 0
Excel does not accept text format! 0

Top