Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a function that will return info of the cursor location?
Is there a function that I could place in cell A1 that will return
information on whatever cell is selected in on the spreadsheet? So for instance, if the current cursor position is in cell D3, I would like cell A1 to display "D3". And if I move the cursor to cell E5, I would like cell A1 to display "E5" |
#2
|
|||
|
|||
Not a function but event code
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("I1").Value = Target.Address(False, False) End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "cbre_bryork" wrote in message ... Is there a function that I could place in cell A1 that will return information on whatever cell is selected in on the spreadsheet? So for instance, if the current cursor position is in cell D3, I would like cell A1 to display "D3". And if I move the cursor to cell E5, I would like cell A1 to display "E5" |
#3
|
|||
|
|||
For a formula only partial solution:
=CELL("Address") But this will only update when a calculation occurs - not when the cell is selected. . -- Regards, Tom Ogilvy "cbre_bryork" wrote in message ... Is there a function that I could place in cell A1 that will return information on whatever cell is selected in on the spreadsheet? So for instance, if the current cursor position is in cell D3, I would like cell A1 to display "D3". And if I move the cursor to cell E5, I would like cell A1 to display "E5" |
#4
|
|||
|
|||
Hi!
Just wondering.....why do you need a function/formula/code to do this? Right now, if you look directly above cell A1 you'll see what cell is selected. (unless you have chosen to not display the formula bar) Biff "cbre_bryork" wrote in message ... Is there a function that I could place in cell A1 that will return information on whatever cell is selected in on the spreadsheet? So for instance, if the current cursor position is in cell D3, I would like cell A1 to display "D3". And if I move the cursor to cell E5, I would like cell A1 to display "E5" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Function to Return another Worksheets Name | Excel Worksheet Functions | |||
Return value with using Excel function | New Users to Excel | |||
Function to return colour of formatted cell | Excel Worksheet Functions |