[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