Adapting from a David McRitchie's post,
and assuming cell A225 contains: 5
think you could try:
=HYPERLINK("#'5'!B4",INDIRECT("'"&$A225&"'!B4"))
where INDIRECT("'"&$A225&"'!B4") returns the data in '5'!B4
which will display in the formula cell as the hyperlinked text.
You may wish to check out more info at David's:
http://www.mvps.org/dmcritchie/excel....htm#hyperlink
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Skot" wrote in message
...
I have a formula;
=HYPERLINK(INDIRECT($A225&"!"&"$B$4"),INDIRECT($A2 25&"!"&"$B$4"))
that is not working. It comes up with an error message "Cannot open
specified file".
Originally, the cell contained the following formula, but i'm trying to
put
a hyperlink over the top of it.
=INDIRECT($A224&"!"&"$B$4")
This indirect statement basically returns the data in workbook / cell
'5'!B4. I want to be able to hyperlink to that.