It is some functions who insert rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cineva - 18 Nov 2005 21:06 GMT

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

Reply to this Message

Chip Pearson - 18 Nov 2005 21:11 GMT

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.

Signature

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

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

Reply to this Message

Lee Harris - 18 Nov 2005 21:24 GMT

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

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?

Reply to this Message

David McRitchie - 19 Nov 2005 21:46 GMT

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" <lee.harris4@virgin.net> 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?

Reply to this Message