Hi pQp.

I may have tottally misunderstood - in which case apologies - but perhaps
you are looking for syntax like:

=Sheet2!A15
or

=SUM(Sheet2!B4:B6)

---
Regards,
Norman



"pQp" wrote in message
...
I think I'm missing a vital point here. I often use existing (not defined)
labels to reference cells or calculate values on a sheet. Can I also do
this
from a different sheet without defining ranges by somehow adding the sheet
name in the reference? (Tried a few permutations of this idea but always
get
a #name? error.)
TIA