I just tested this using on Excel 2007 SP1 and it worked correctly -
the Hyperlink took me to the named range.

Is your Excel 2007 up to date?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup