Excel: HYPERLINK function question 1

[RandDUser]

In cell A1, I have the following formula:

=HYPERLINK(B7, "Click Here")

I want it so that when the user clicks on cell A1, the focus is moved to cell B7. The above formula does not work though. I am using Excel 2000.

Any suggestions?

TIA

 

[Fenrirshowl]

Looks like you missed out the workbook name and the sheet name in the path to B7. From the function help file it should follow the format:

HYPERLINK("[Budget]June!B7",B7)

Where Budget is the workbook and June in the worksheet.

Fen

 

[GlennUK]

How about:

=HYPERLINK("#B7","friendly text")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[RandDUser]

the "#B7" worked great, thank you!!

 

[GlennUK]

My pleasure!

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.