Hello,
I would like to have that the address of the active cell of a sheet is shown in a certain cell of another sheet.
Can this be programmed as a "Sub" or even better as a "Function"?
Thank you very much for your help
Florian
Hello,
I would like to have that the address of the active cell of a sheet is shown in a certain cell of another sheet.
Can this be programmed as a "Sub" or even better as a "Function"?
Thank you very much for your help
Florian
sure,
you can even do it in a formula
in cell H3
The result is $C$3Please Login or Register to view this content.
But a macro
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Keebellah; 06-01-2018 at 05:57 PM.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Dear Keebellah,
thanks for your reply.
There seems to be a misunderstanding.
I'd like to have a cell in sheet (e.g. A1) which always outlines the active cell of a sheet.
Thus, if I select B3, in A1 is displayed "B3"; if I click then on C26, in A1 is displayed "C26".
Hope these details bring a little light into the dark.
Florian
Maybe this ? Put in sheet module.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
@ Bakerman2
You don't need to use replace to create an relative address. The address property has this built-in to it.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello bakerman and Leith,
thanks a lot for your replies.
It works now perfectly.
Florian
@ Leith
Thanks for head's up.
@ Florian
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks