Rather than referencing a range for a given Name, I have typed in a formula,
which typically works. However, I have noted that when using a formula that
includes other named ranges, I get the #VALUE error. Is there a way around
this, or is it simply a weakness in Excel?