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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Repeating a row other than the 1st row as the header row in a table from next page 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Code to cut a paragraph that's followed by a table 2
Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0
Changing row background from external program 0
Macro to select and delete levels of a document 2

Top