Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert a row
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.. |
#2
|
|||
|
|||
Insert a 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. "Mindie" wrote in message ... 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.. |
#3
|
|||
|
|||
Insert a row
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 -- Don Guillett SalesAid Software "Mindie" wrote in message ... 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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simultaneouly insert of rows or col. - Ajit | Excel Discussion (Misc queries) | |||
insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |