get current cell address

[mwesterman]

I need to be able to return the current cell address (row and column) as shown in the "refernce area".

 

[NBVC]

You can use:

=ADDRESS(ROW(),COLUMN())

 

[Cbrine]

Using code this will work, but I would suggest you use the formula option, if it works, but the code will dynamically update the cell value. The formula won't without a recalculation.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("C20") = ActiveCell.Address
End Sub

HTH
Cal

 

[Von Pookie]

Going from what you specify in your other post (which should have been a reply in this thread instead of a new thread):

In a particular cell (c20, for instance), I want that cell to always display the address (row and column) of the current cell that I have clicked on. Thus, cell c20 would display whatever location is shown in the upper left hand reference area.

Use:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

[C20] = Target.Address
End Sub

Right-click the sheet tab you want to use it on, select "View Code," and paste the code in the VBE window that is opened.

 

[Von Pookie]

Using code this will work, but I would suggest you use the formula option, if it works, but the code will dynamically update the cell value. The formula won't without a recalculation.

Actually, that particular formula won't work at all for the question at hand. Well, it *will* work for returning the address of the cell it is entered in (which is what the OP seemed to be asking at first), but not for the address of the cell that is selected (as the OP specified in the post I linked to this thread).

 

[Cbrine]

VP,
I actually posted to the dead link originally, and figured this was a duplicate post, now I realize the other post had more information.

Cal