Please Login or Register to view this content.
Excel cell coordinates. Example in the above code for a UF I have placed a text box to show value of cell in Col 18 and Row 11. My question is: Is there a way to find that coordinated without physically counting each Row and Column?
Thanks
cells(18,11) is row 18 column 11 which is K18, a fixed address.
Where does the finding and counting come into it?
If you have column and row headings, you could use Application.WorksheetFunction.Match to get the column and row numbers. The headings would have to be unique as Match will return the first one it finds.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
ByteMarks, Sorry, you're correct. Had those settings backassward but still like to know is there is a code or something that if you click on any cell, it will let you know in this example something like this: R11,C18.
Thanks
TMS, mighty warrior, could you show me a small example.
Thanks
This:
Please Login or Register to view this content.
For the address of the Active Cell:Please Login or Register to view this content.
You're welcome. Thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
@ByteMarks: thanks for the +rep.
The thread is still not marked solved and there has been no confirmation that the solution was what was being looked for. We can only assume that it was
TMS - It's not solved, at least for me, but marking it Solved. Thanks for helping.
How can we help?
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
TMS, I found it. I knew I had done it before but getting old and memory stick broken. Click on File Tab, go to Options, click on Formulas, and find “Working with formulas” and check this and any cell clicked on will give you the coordinates “R18C11” which is my example above. However, it only seems to work on the worksheet you are currently using.
Last edited by jevicha2; 03-21-2024 at 04:46 PM.
Good..
Not sure if this helps, but you can get the activecell address in R1C1
Further to post #7
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks