mwesterman
New Member
- Joined
- Nov 15, 2005
- Messages
- 2
I need to be able to return the current cell address (row and column) as shown in the "refernce area".
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
get current cell address
- Thread starter mwesterman
- Start date
Cbrine
Well-known Member
- Joined
- Dec 2, 2003
- Messages
- 3,196
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.
HTH
Cal
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("C20") = ActiveCell.Address
End SubHTH
Cal
Upvote
0
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Going from what you specify in your other post (which should have been a reply in this thread instead of a new thread):
Use:
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.
Use:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
[C20] = Target.Address
End SubRight-click the sheet tab you want to use it on, select "View Code," and paste the code in the VBE window that is opened.
Upvote
0
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Cbrine said:
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).
Upvote
0
Similar threads
