What I posted was the hyperlink FUNCTION, not the hyperlink OBJECT. The two
are different (coming in to being in different version of Excel). You need
the entire formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Maui Dave" wrote in message
...
Chip, I copied and pasted what you put below, but I get an error message
(I
did put the appropriate cell number in there). Does the =HYPERLINK need
to
be in there?

"Chip Pearson" wrote:

Try

=HYPERLINK("#K20","Click Me")

to go to cell K20 on the same sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Maui Dave" wrote in message
...
How do I hyperlink to a cell in the same spreadsheet? I know I go to
Insert/Hyperlink, but what's the syntax to go to cell BB:2 ?

Thanks in advance