Ask Your Question

JohnL's profile - activity

2014-06-16 00:22:54 +0100 received badge  Nice Question (source)
2013-07-31 19:46:29 +0100 received badge  Famous Question (source)
2013-07-31 19:46:29 +0100 received badge  Notable Question (source)
2013-05-12 13:59:57 +0100 received badge  Popular Question (source)
2012-03-21 00:09:11 +0100 received badge  Student (source)
2012-03-20 16:02:58 +0100 asked a question seeking clarification of range name scope in Calc

background ( all sheets in the same file ): one sheet named LECO - with a range name TotalShares defined with scope local one sheet named MDY - with a range name TotalShares defined with scope local one sheet named test - with a range name TotalShares defined with scope local one sheet named SummaryPositions

In a formula in the SummaryPositions sheet can I refer to the TotalShares range in the LECO sheet as LECO.TotalShares? When TotalShares was created in the LECO sheet it's scope was declared as local.