VB Code For Taking a user to a named cell

[Brady Finney]

Hi,

I have a long table of contents for a large excel model. I'd like to have a
button next to certain items, that when the user clicks the button, Excel
will take the user to that named Cell. Can anyone tell me what VB code
would go in a command button to allow me to do this?

Any help would be huge, thank you.

Brady

 

[Earl Kiosterud]

Brady,

You can do this using Insert - Hyperlink. Place in this document. No code
required for this solution.

 

[Don Guillett]

Sub gotonamedcell()
Application.Goto Range("namedcell")
End Sub