It is some functions who insert rows?

C

Cineva

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

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
 
L

Lee Harris

Chip Pearson said:
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
Click to expand...


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?
 
D

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.
 
Top