Static formula when inserting new rows/columns?

Giganews Newsgroups
Subject: Static formula when inserting new rows/columns?
Posted by:  nfe (nfe.276ium_1146571801.2949@excelforum-nospam.com)
Date: Tue, 2 May 2006

I have a sheet that i want to make a macro for. However i dont want the
formulas to update to the new cell references when i insert new
columns/rows. Ive tried locking the cells but the it still updates.

The other idea ive had is just add the formula editing to the macro.
However this is a bit long winded.

Thanks in advance

--
nfe
------------------------------------------------------------------------
nfe's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34037
View this thread:http://www.excelforum.com/showthread.php?threadid=538007

Replies