Technische Foren » Office applications »
Excel: how to get current cell's address
Initiator des Themas: Samuel Murray
Samuel Murray
Samuel Murray  Identity Verified
Niederlande
Local time: 11:33
Mitglied (2006)
Englisch > Afrikaans
+ ...
Oct 18, 2021

Hello everyone

Is there a function or functionality in Excel (latest version) that will get me the current cell's address? I mean, if I click a cell (say, A22), and press a shortcut or use a menu, I want "A22" to be added to the clipboard. Does anyone know how to accomplish this?

Thanks
Samuel
 
Samuel Murray
Samuel Murray  Identity Verified
Niederlande
Local time: 11:33
Mitglied (2006)
Englisch > Afrikaans
+ ...
THEMENSTARTER
One solution Oct 18, 2021

The first solution that I found (which is a manual process, but you can do it using just the keyboard), is this:
1. Right-click the cell, and press "a" (Define name).
2. Press Alt+R (this selects the text in "Refers to").
3. Press Ctrl+C to copy, and convert the content to a cell address. E.g. if the worksheet is named "Hello", then you'd get "=Hello!$A$22", which is A22.
 
Joakim Braun
Joakim Braun  Identity Verified
Schweden
Local time: 11:33
Deutsch > Schwedisch
+ ...
VB script Oct 18, 2021

https://stackoverflow.com/questions/2202093/get-the-current-cell-in-excel-vb/42361786
https://www.wallstreetmojo.com/vba-active-cell/
... See more
https://stackoverflow.com/questions/2202093/get-the-current-cell-in-excel-vb/42361786
https://www.wallstreetmojo.com/vba-active-cell/
https://www.excelcampus.com/vba/keyboard-shortcut-run-macro/

Write a macro (VB script) and set a shortcut for it.
It's three lines of code or so. ▲ Collapse
 
Endre Both
Endre Both  Identity Verified
Deutschland
Local time: 11:33
Englisch > Deutsch
Autohotkey Oct 19, 2021

Hi Samuel, you have been using AutoHotkey in the past, right? Here's a snippet that copies the current cell reference to the clipboard when you press Alt+F1:

!F1::
    xl := ComObjActive("Excel.Application")
    currentCellRef := xl.ActiveCell.Address ; e.g. $A$1
    currentCellRef := RegExReplace(currentCellRef, "\$", "") ; $A$1 -> A1
    Clipboard := currentCellRef
return
 
Samuel Murray
Samuel Murray  Identity Verified
Niederlande
Local time: 11:33
Mitglied (2006)
Englisch > Afrikaans
+ ...
THEMENSTARTER
Thanks, everyone Oct 19, 2021

Thanks for your ideas. I may try them out in a future job. I had to complete the current job in record time. It involved pasting the translation of e.g. cell AAA21 into e.g. cell AAF21 etc. I copied all cells to Word, converted them to a plain text list, and then translated them, and then copy/pasted the translations into the appropriate cells in Excel. Being able to tell my script what a cell's address is helped me for instances where the "translation" cells were not in predictable locatio... See more
Thanks for your ideas. I may try them out in a future job. I had to complete the current job in record time. It involved pasting the translation of e.g. cell AAA21 into e.g. cell AAF21 etc. I copied all cells to Word, converted them to a plain text list, and then translated them, and then copy/pasted the translations into the appropriate cells in Excel. Being able to tell my script what a cell's address is helped me for instances where the "translation" cells were not in predictable locations. ▲ Collapse
 


To report site rules violations or get help, contact a site moderator:

Moderatoren dieses Forums
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Excel: how to get current cell's address






LinguaCore
AI Translation at Your Fingertips

The underlying LLM technology of LinguaCore offers AI translations of unprecedented quality. Quick and simple. Add a human linguistic review at the end for expert-level quality at a fraction of the cost and time.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »