Insert row adds formula to cell

Giganews Newsgroups
Subject: Insert row adds formula to cell
Posted by:  Johnny G
Date: Wed, 15 Aug 2007

I have a hidden column with a similar formula in each cell. For example cell
B2 is "=month(A2)", B3 is "=month(A3), etc. There are time when a row has to
be inserted, and since the B column is hidden from the end user I would like
to automatically add the formula to the cell added in the B column. Hope that
is easy to follow ;)

Replies