Not with a formula, only with VB code. A cell formula can only change the
value of another cell (or cells). It can be done, but you need to give more
information of what you are trying to achieve,
Regards,
"Doug" wrote in message
...
Is there a way to insert a new row based on the value in a cell of an
existing row?

Thanks in advance for any help.