Beach Access Software
bchacc at san.rr.com
Sat Oct 7 16:30:38 CDT 2006
Dan says so! :o) Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten Sent: Saturday, October 07, 2006 1:47 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OT: Excel Question - Lock a Formula Hi Rocky Are you looking for $E$4 to lock to E4 ?? Not sure I understood the question but thought I'd give it a try. HTH Bill ----- Original Message ----- From: "Beach Access Software" <bchacc at san.rr.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Saturday, October 07, 2006 1:00 PM Subject: [AccessD] OT: Excel Question - Lock a Formula Dear List: I have a formula in a cell in Column E that averages the next 12 cells in the row (=(F4-R4)/R4). When I insert a column after this formula, it changes the formula to =(G4-S4)/S4. I would like the formulas in column E to not change. Everything else can. Is there a way to ‘lock’ the formulas in just this column? MTIA Rocky -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006