insert a new row by formula
 

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.

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.

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



Alan wrote:

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.


--

Dave Peterson

I did indeed! Sorry,
Alan,
"Dave Peterson" wrote in message
...
I bet Alan meant to say that a formula can only return values to the
cell(s)
containing the formula.



Alan wrote:

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.


--

Dave Peterson