Select Range address as displayed in another Cell

[myou]

Hi Guys,

I have a column with a list of Cell Addresses and would like to know if it is possible to select any such address if I click or double click on anyone of those Cells?

All help is most most welcome.

Thank you.

[alansidman]

This would be your starting point

Please Login or Register  to view this content.

[myou]

Many Thanks, Mr. alansidman,

The "some code" is my real problem, which is how to go to the address as displayed in the ActiveCell.

[alansidman]

Please explain what you want here. I don't understand as when you have clicked on the cell it is active.

Please Login or Register  to view this content.

[myou]

Thank you, Mr. alansidman,

The activecell which may be Cell B2 holds a Cell Address of say $A$55. Now when I click in Cell B2, the Code should take me to the Range $A$55.

Is it more clear for you now?

[alansidman]

Maybe

Please Login or Register  to view this content.

[myou]

No Sir, it is not "Maybe" but "Surely",.

Thank you, thank you!

Is there a line I could add to scroll to that same Cell Address?

[sktneer]

I think you need this...

Please Login or Register  to view this content.

[Winon]

Hello myou,

Is there a line I could add to scroll to that same Cell Address?

Expanding on what alansidman provided you with, you may try the below:

Please Login or Register  to view this content.

Regards.

[xlnitwit]

Perhaps this

Please Login or Register  to view this content.

[Winon]

Hello myou,

Is there a line I could add to scroll to that same Cell Address?

Please try the following Changes;

In a standard module:

Please Login or Register  to view this content.

In Sheet1 Event Code:

Please Login or Register  to view this content.

Please try the attached sample Workbook.

Remember to mark the Thread as solved if tou are satisfied with the solution provided.

Regards.