An easy way to "lock" a range is to use Indirect and specify the range as a string. E.g. =SUM(INDIRECT("A1:A5")) will always sum A1:A5 regardless of what moves you do. Regards, Dave S ----- Original Message ----- From: <LarrysPCRemedies@xxxxxxx> To: <mso@xxxxxxxxxxxxx> Sent: Wednesday, November 26, 2008 5:00 AM Subject: [mso] Re: Excel "insert" > Good point, I forgot about that. Mea Culpa. But changing the range s/b > simpler than inserting a bunch of. > > Too bad Excel can't permanently "lock" a range. > > Larry > --- On Mon, 24 Nov 2008 18:39:53 -0800 (PST) Jonathan Drawer > _jdrawer07@xxxxxxxxxx (mailto:jdrawer07@xxxxxxxxx) wrote: > From: Jonathan Drawer <jdrawer07@xxxxxxxxx> > Subject: [mso] Re: Excel "insert" > > In my experience, if the value in Column A of Row 151 is found as the > sum(A1:A150) then the process of selecting rows 2 through 150 in Column > A, choosing > to Cut the selection, and Paste into Row 1 will result in the expression > in > Row 151 changing to sum(A1:A149). The entry in Row 150 of Column A will > no > longer be included in the SUM. To not have the relationship in Row 151 > change > it is necessary to use the process of selecting rows 2 through 150, COPY > the > selection, Paste the selection starting in Row 1, select the entries in > Row > 150 and delete the selection or modify it with new data. > Jonathan > > --- On Mon, 11/24/08, LarrysPCRemedies@xxxxxxx <LarrysPCRemedies@xxxxxxx> > wrote: > From: LarrysPCRemedies@xxxxxxx <LarrysPCRemedies@xxxxxxx> > Subject: [mso] Re: Excel "insert" > To: mso@xxxxxxxxxxxxx > Date: Monday, November 24, 2008, 4:23 PM > > I'm not exact sure I understand what you want to do, but if you have your > total/average line on row 151, and you delete row 1 and insert new values > in > row > 150, why don't you just cut the rows 2-150 and paste into rows 1-149. > That > > will open up row 150 for the new data without needing to insert any rows > at > > all. > > Larry > > > > **************One site has it all. Your email accounts, your social > networks, > and the things you love. Try the new AOL.com > today!(http://pr.atwola.com/promoclk/100000075x1212962939x1200825291/aol?redir=http://www.aol.com/?optin=new-dp > %26icid=aolcom40vanity%26ncid=emlcntaolcom00000001) > > > ************************************************************* > You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or > MicrosoftOffice@xxxxxxxxxxxxxxxx > > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx > > To Unsubscribe from this group, visit the group's homepage and use the > dropdown menu at the top. This will allow you to unsubscribe your email > address or change your email settings to digest or vacation (no mail). > //www.freelists.org/webpage/mso > > To be able to share files with the group, you must join our Yahoo sister > group. This group will not allow for posting of emails, but will allow > you to join and share problem files, templates, etc.: > http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for > FILE SHARING ONLY. > > If you are using Outlook and you see a lot of unnecessary code in your > email messages, read these instructions that explain why and how to fix > it: > http://personal-computer-tutor.com/abc3/v28/greg28.htm > ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************