INDIRECT basically resolves/"activates" concatenated strings into desired
range references. The 2 apostrophes work as a pair (you missed the front
ones earlier). They're needed once the sheetname contains a space/s. For
sheetnames w/o any spaces, the apostrophes are not needed, but its still
fine with the apostrophes inserted. Hence its safer in general to always use
the pair of apostrophes.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"jbo" wrote in message
...
That worked great. Thanks! Can you explain to me why that worked? I
just
discovered the indirect formula yesterday and, therefore, do not really
understand how the apostrophe's and & symbols work to construct the
formula.