insert a new row by formula

D

Doug

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.
 
A

Alan

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,
 
D

Dave Peterson

I bet Alan meant to say that a formula can only return values to the cell(s)
containing the formula.
 
Top