Not just only when there are spaces.

If the worksheet name is a number, you'll need them, too.
='1234'!a1

To the OP:
If you're building a formula, if you add them and excel doesn't need them, excel
will get rid of them.


Don Guillett wrote:

Only if spaces in the sheet name

my sheet name yes
mysheetname no

--
Don Guillett
SalesAid Software

"David Smithz" wrote in message
. uk...

"David Smithz" wrote in message
k...

Ahh, I do have a further question regarding this. What if Sheet1 is
called -
Example Sheet name with space
-
I am looking it up, but if you happen to know off hand how I reference
this
worksheet then great. I have tried quotes and brackets with no luck.

anyone know?
Ok found it in the end. I needed to use single quotations.

Thanks for input.



--

Dave Peterson