Is there any way to set cells or any new cells (via inserting rows and
columns) to default formula(s)? For example if i inserted a row can the
cells in that row be set up to contain a default formula?

Since inserting a row or a column does not trigger an event this is going to
be very difficult at best. Probably not worth doing. If you wanted to try it
you will need to do it vai a form. This would work similar to Data - Form
from the Excel Menu.
--
HTH...

Jim Thomlinson


"Adam" wrote:

Is there any way to set cells or any new cells (via inserting rows and
columns) to default formula(s)? For example if i inserted a row can the
cells in that row be set up to contain a default formula?