Article View: comp.apps.spreadsheets
Article #116Re: Protecting end-points of a named range
From: R. J. Glew
Date: Thu, 20 Aug 1992 22:26
Date: Thu, 20 Aug 1992 22:26
31 lines
1455 bytes
1455 bytes
In article <RON.92Aug19115827@bert.cs.byu.edu> ron@bert.cs.byu.edu (Ron Snyder) writes:
> I have some budget sheets that are used by several accountants
>in my department. The budget have many(!) named ranges that are
>accessed by other worksheets. Today one of the area heads called
>me because a summary worksheet that refers to these named ranges
>is giving the wrong answers (like ERR). It didn't take long to
>figure out that between he and his accountants, some of the endpoints
>of the named ranges had been inadvertently deleted while they were
>'cleaning' up the budget worksheet.
If I understand your question correctly, you want users to be able to add or
delete rows without losing range name references.
A B C
1
2 \- \-
3 200 123
4 344 767
5 666 444
6 335 569
7 \- \-
8
/rncFIRST~A2.B7~
User Rules:
"You can delete or add rows ONLY between the two dashed lines."
Technical Details
Message-ID:
<rglew.106@cs-acad-lan.Lakeheadu.Ca>Path:
arc1-ca.pugleaf.net!sparky!uunet!utcsri!torn!thunder!bus-rb1034.lakeheadu.ca!rglewReferences:
<RON.92Aug19115827@bert.cs.byu.edu>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!utcsri!torn!thunder!bus-rb1034.lakeheadu.ca!rglew From: rglew@cs-acad-lan.Lakeheadu.Ca (R. J. Glew) Newsgroups: comp.apps.spreadsheets Subject: Re: Protecting end-points of a named range Message-ID: <rglew.106@cs-acad-lan.Lakeheadu.Ca> Date: 20 Aug 1992 22:26:21 GMT References: <RON.92Aug19115827@bert.cs.byu.edu> Sender: news@thunder.LakeheadU.Ca Distribution: comp.apps.spreadsheets Organization: Lakehead University Lines: 33