Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Insert a row that includes copied formulas
I may be in way over my head here (I have never written or used any
macros before) but I am trying to write a macro that will do the following: 1. Find the next blank row after row 4 in column B. 2. Insert a new row at that point, shifting the entire row(s) below the new row down. 3. Copy the formulas contained in J2:Q2 into this new row. I have been searching through this group and other web sites for the programming to do this but have not found anything close enough to what I need, that I am then am to alter the exact cell/column numbers to fit. I would greatly appreciate any and all help. Thanks Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Insert a row that includes copied formulas
Hi Andy,
Take a look at InsertRowsAndFillFormulas at Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "A Maurer" wrote in message om... I may be in way over my head here (I have never written or used any macros before) but I am trying to write a macro that will do the following: 1. Find the next blank row after row 4 in column B. 2. Insert a new row at that point, shifting the entire row(s) below the new row down. 3. Copy the formulas contained in J2:Q2 into this new row. I have been searching through this group and other web sites for the programming to do this but have not found anything close enough to what I need, that I am then am to alter the exact cell/column numbers to fit. I would greatly appreciate any and all help. Thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Copied Rows or Drag/Drop Formulas While Protected | Excel Worksheet Functions | |||
Find most recent value in data range that includes SUM formulas | Excel Worksheet Functions | |||
Insert copied row based on value | Excel Worksheet Functions | |||
Insert copied cells | Excel Worksheet Functions | |||
insert copied cells | Excel Discussion (Misc queries) |