It is some functions who insert rows?
 

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

It is some functions who insert rows?
 

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


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

It is some functions who insert rows?
 

"Chip Pearson" wrote in message
...
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?

It is some functions who insert rows?
 

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

"Lee Harris" wrote in message news:FErff.4659
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?