The error is that excel is not accepting the formula. I have tried adding the
spaces like you suggested. No success. It seems as if i cannot put a cell
reference in a formula which will represent a sheets name

"Madhan" wrote:

Hi,

The following are my observations.
1. You shoud leave a space before and after & to concatenate two strings
2. You have not specified the exact error message !!

"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