Macro to Hyperlink Tab to a defined name

[Revnou]

Hi Everyone,

Anyone can assist with a Macro? I defined a cell an excel book (usually it is only on sheet ) and create a tab with the exact name based on the define name. How do I create a hyperlink based on the tab's name back to the define name?

For Example.
I am in worksheet "Peet_A".
The define Cell is somewhere in the workbook.

If I am in worksheet "Peet_A" and I select cell A1, how do I put a hyperlink in cell A1 to the define name "Peet_A" that is somewhere located in the workbook. Same situation, if I am in cell B33 in "Peet_A", how do I hyperlink back to the define name?

Usually, my define name is only on one spread sheet. The spreadsheet is very long and I tend to loose my place. To have a tab automatically hyperlink to the define name helps. Thanks.

 

[My Aswer Is This]

Why not create a Macro and assign a shortcut key to take you to the named range. Does not need to know the sheet name.
Like this:

Sub Goto_Me()
Application.Goto Range("Master")
End Sub

 

[Revnou]

Why not create a Macro and assign a shortcut key to take you to the named range. Does not need to know the sheet name.
Like this:

Sub Goto_Me()
Application.Goto Range("Master")
End Sub

Hi,

Thank you for taking time to reply. The problem is when I get back to the page that has the range of data, I keep having to do control F to find my place again. I was hoping to avoid that.

 

[My Aswer Is This]

Hi,

Thank you for taking time to reply. The problem is when I get back to the page that has the range of data, I keep having to do control F to find my place again. I was hoping to avoid that.

You said:
The problem is when I get back to the page that has the range of data,
We do not refer to them as pages we refer to them as sheets.

So I thought you always wanted to get to the range named something I used "Master" . So where was your place . when you use control F what are you trying to fine? I dont see how control F can fine the last place where you were.

 

[Revnou]

Disregard, turns out I just needed dynamic hyperlink.

Source: https://www.extendoffice.com/documents/excel/5847-excel-dynamic-hyperlink-based-on-cell-value.html

 

[Revnou]

You said:
The problem is when I get back to the page that has the range of data,
We do not refer to them as pages we refer to them as sheets.

So I thought you always wanted to get to the range named something I used "Master" . So where was your place . when you use control F what are you trying to fine? I dont see how control F can fine the last place where you were.