It is some functions who insert rows?

[Guest]

It is some functions who insert rows?
I want to insert 2 blank rows afther each row from my table (not manual)
Thanks

 

[Chip Pearson]

You'd need some VBA code to do this. A formula can't change
anything about a worksheet -- it can only return a value to the
cell which called it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Lee Harris]

You'd need some VBA code to do this. A formula can't change anything about
a worksheet -- it can only return a value to the cell which called it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

couldn't you add a 2nd worksheet where every 3rd row references the contents
of consecutive rows in the original sheet, do that for a couple of rows and
then auto fill down the page?

 

[David McRitchie]

The idea of a second worksheet is good, if created with a macro
for display printing purposes with values only, but that is not what
is done in Guarantee2RowsAfterA_values which you will
find at http://www.mvps.org/dmcritchie/excel/insrtrow.htm#morex

You can rerun it and it will not insert additional rows,
but it won't delete any if you already had too many (3 empty rows)
between.