That is the solution, but the formula actually is:
=HYPERLINK("#"&CELL("address",INDIRECT("'"&Intro!A 3&" 1-7'!A3")),A2)
without the quotation marks after the 7

Thanks

Yes exactly. I've been trying to grab the sheet's name from that cell.
maybe you can explain why the regular reference wouldn't work and i would
need the indirect function.

"Dave Peterson" wrote:

Try wrapping that range in =indirect().

=HYPERLINK("#"&CELL("address","'"&Intro!A3&" 1-7'"!A3),A2)
becomes
=HYPERLINK("#"&CELL("address",indirect("'"&Intro!A 3&" 1-7'"!A3")),A2)

You're really trying to grab the worksheet name from Intro!A3?

If this doesn't work, describe what's in each of those cells and where you want
the link to point.

Jared wrote:

I am trying to use the cell function to create a dynamic hyper link to
several sheets.
i can use: =HYPERLINK("#"&CELL("address",'Mall1 1-7'!A3),A2)
but i need to do a whole bunch and the sheet names change frequently so i
try:
=HYPERLINK("#"&CELL("address","'"&Intro!A3&" 1-7'"!A3),A2)
I keep getting error messeges.

Help

--

Dave Peterson