Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert rows in excel spreadsheet via macro
I need to be able to insert a number into a column in an Excel Spreadsheet
and have that number of rows (copied from another row) entered following that row. |
#2
|
|||
|
|||
With VBA
ActiveCell.Offset(1, 0).Resize(ActiveCell.Value).EntireRow.Insert -- HTH Bob Phillips "Floyd Elkins" <Floyd wrote in message ... I need to be able to insert a number into a column in an Excel Spreadsheet and have that number of rows (copied from another row) entered following that row. |
#3
|
|||
|
|||
Thanks Bob - I really appreciate the prompt response! I need to be able to
go to a specific column (heading = Quantity). Based on the number entered, I want to enter that number of rows immediately following this entry. I'm not sure that a Macro is the right way to do this, and I can't find a command that will do it. Any suggestions? Thanks again, Floyd "Bob Phillips" wrote: With VBA ActiveCell.Offset(1, 0).Resize(ActiveCell.Value).EntireRow.Insert -- HTH Bob Phillips "Floyd Elkins" <Floyd wrote in message ... I need to be able to insert a number into a column in an Excel Spreadsheet and have that number of rows (copied from another row) entered following that row. |
#4
|
|||
|
|||
Bob's VBA command does just what you want.
If you are not comfortable with macros/VBA, get a quick tutorial at David McRitchie's website http://www.mvps.org/dmcritchie/excel...m#vbatutorials "Floyd Elkins" wrote: Thanks Bob - I really appreciate the prompt response! I need to be able to go to a specific column (heading = Quantity). Based on the number entered, I want to enter that number of rows immediately following this entry. I'm not sure that a Macro is the right way to do this, and I can't find a command that will do it. Any suggestions? Thanks again, Floyd "Bob Phillips" wrote: With VBA ActiveCell.Offset(1, 0).Resize(ActiveCell.Value).EntireRow.Insert -- HTH Bob Phillips "Floyd Elkins" <Floyd wrote in message ... I need to be able to insert a number into a column in an Excel Spreadsheet and have that number of rows (copied from another row) entered following that row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
how do I insert a watermark onto an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
can't insert more rows even though not at max rows | Excel Worksheet Functions | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |