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

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

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

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?