Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Are you looking for something as is demonstrated in this example?
The HYPERLINK() function should be the appropriate means for the purpose. However, it seems to be a bit fragile in its working if editing is done.
Anyway you don't need named ranges if it's ok for you to jump to cell A1 of any chosen sheet.