Insert a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible based on a formula to insert an additional row. For example,
If cell A5=25, I want to insert a row and duplicate the existing row..
 
A formula in a cell can only change the value in that cell, it cant change
anything else unless you use VBA code by using the Worksheet_Change event or
suchlike,
Regards,
Alan.
 
Not with a formula. Formula only return values. You can use a macro

if range("a5")=25 then
ActiveCell.EntireRow.Copy
ActiveCell.Offset(1).entirerow.Insert
Application.CutCopyMode = False
 
You must log in or register to reply here.

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

SUM Char 9
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
How can I reference a worksheet in a formula based on a cell value 2
Formulas Affected by Insert Row 7
Insert row with a locked cell 1
Dissabling Error when editing formula with Find+Replace 2
VBA - retrieve data on last create named range from previous inserted named range 0
insert blank row and formulas 1

Back
Top