Using Hyperlink Function

  • Thread starter Thread starter Ailish
  • Start date Start date
A

Ailish

Hi

I am using the following formula in A1 in Sheet1 to link to Sheet3 C5. The
formula seems correct and is in blue and underlined. But when I point the
mouse at the cell although I get the hand to indicate a link when I click
nothing happens. It is a brand new workbook so the sheets it is trying to
find etc. are there.

=HYPERLINK(Sheet3!C5,"Click Here")

Any Ideas?

Thanks
Ailish
 
Try it this way:

=HYPERLINK("#Sheet3!C5","Click Here")

The # is needed to indicate "this workbook" - it's an HTML thing - and
the quotes are needed as it can be a calculated address.

Hope this helps.

Pete
 
I'd use something like this:

=HYPERLINK("#"&CELL("address",sheet3!C5),"Click Here")

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

The thing that's very nice about David's syntax is that if you insert or delete
rows/columns in Sheet3, then the formula will point to the new location.

This syntax:
=HYPERLINK("#Sheet3!C5","Click Here")

Will always point at C5 of Sheet3--no matter if you insert/delete rows or
columns.

So you'll want to choose the one that fits your requirements.
 
Thanks a million for the reply worked a treat.

Ailish



Dave Peterson wrote:

Re: Using Hyperlink Function
25-Aug-09

I'd use something like this

=HYPERLINK("#"&CELL("address",sheet3!C5),"Click Here"

David McRitchie posted this and it might help you

=HYPERLINK("#"&CELL("address",C5),C5
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5

The thing that's very nice about David's syntax is that if you insert or delet
rows/columns in Sheet3, then the formula will point to the new location

This syntax
=HYPERLINK("#Sheet3!C5","Click Here"

Will always point at C5 of Sheet3--no matter if you insert/delete rows o
columns

So you'll want to choose the one that fits your requirements

Ailish wrote

--

Dave Peterson

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx
 
Back
Top