#1   Report Post  
Mindie
 
Posts: n/a
Default 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   Report Post  
Alan
 
Posts: n/a
Default 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   Report Post  
Don Guillett
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simultaneouly insert of rows or col. - Ajit Ajit Munj Excel Discussion (Misc queries) 1 March 23rd 05 09:17 AM
insert a JPEG into EXCEL 2002 mckee Excel Discussion (Misc queries) 3 March 11th 05 05:03 PM
insert picture BillGwyer Excel Discussion (Misc queries) 1 March 4th 05 06:37 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"