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.

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.

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.

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.