That # is the subaddress indicator for the link.

This link:
http://contextures.com/xlFunctions02.html
will take you to the top of one of Debra Dalgleish's pages.

This link:
http://contextures.com/xlFunctions02.html#Trouble
will take you to the section(?) named Trouble on that page.

You may want to change the hyperlink style so that it's the way you want.

In xl2003:
format|Style
Use the dropdown to choose Hyperlink
Click Modify
and make it what you want.

Styles live in workbooks. So this change won't have any effect on any other
workbook.


Hershey wrote:

Thanks, Max
I learned to make use of 'address' info type
I learned to enclose sheet names within apostrophes
I noticed that the number sign has an effect on formatting, but I don't
understand why
The hyperlinked text is not underlined or blue, and is an isle of Veranda in
a sea fo Arial. How?

"Max" wrote:

In Sheet1,
I got this rendition to work ok:
=HYPERLINK("#"&CELL("address",INDIRECT("'"&A3&"'!A 1")),A3)
where in A3: Sheet2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,900 Files:354 Subscribers:53
xdemechanik
---
"Hershey" wrote:
I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2.
The value of Sheet1!A3 is Sheet2.
I'm entering this formula, and no error value is returned, but it just
doesn't go there.
Here is the formula:

=HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3)

Any ideas?



--

Dave Peterson