Hyperlinking to a Sheet using INDIRECT Reference

[tomlancaster]

Hello, I would like to hyperlink to another sheet using the indirect Reference.

I have this so far but when clicked it says cannot open the file specified.

=HYPERLINK(INDIRECT("'"&B6&"'!A1"),1)

Does anyone know whal else I need to put in to link this cell to another sheet in the same workbook?

Regards,
Tom

[DonkeyOte]

You need to use # to indicate it's a relative bookmark and then along the lines of:

=HYPERLINK("#'"&B6&"'!A1",1)

[tomlancaster]

Thanks!