Ayrton

The "'" places ' around the sheet name.

This is rquired if the sheet name has space(s) in it.

='sheet one'!A16 requires the ' ' around the name.

=Sheet2!A13 does not require ' '


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 09:34:42 -0600, Ayrton
wrote:


Thanks a lot. your "grammar" does work but I am not sure why the "'" ...
are for? I cannot find this example in the help...

Anyways, thanks again