Single quotes are required for sheet names that have spaces in them.

=Sheet3!A1

versus

='Sheet 3'!A1

"heski" wrote:


Hi all,

A simple query about references that include parts of the reference (eg
sheet name) in quotation marks.

When is this required?

What purpose does it serve?

Or possibly I am just confused and they are not actually used in this
context.

Thanks for viewing and/or replying.


--
heski
------------------------------------------------------------------------
heski's Profile: http://www.excelforum.com/member.php...o&userid=30581
View this thread: http://www.excelforum.com/showthread...hreadid=509210