Either name that range (a75) (insert|name|define) and point at that name or use
a worksheet formula:

=HYPERLINK("#"&CELL("address",A75),"Click me")



Omunene wrote:

An Excel spreadsheet with names in Column A.
"Bush, George" is in cell A75.
"Dubya" is in cell A125.
I want a hyperlink from "Dubya" to "Bush, George."
If I add or delete rows above "Bush, George," I want the hyperlink to follow
the name, not just keep pointing to call A75.

Help? (Thanks!)

--

Dave Peterson