I need to copy 3 blank rows and insert them in every other row on the sheet.
Is there a way to insert multiple copied cells into multiple locations at one
time? Excel gives me the command cannot be performed with multiple
selections please select a single range error.

.. need to copy 3 blank rows and insert them
But if the row is blank, there's no need to copy it, just insert??

Presuming you meant that you want to insert 3 blank rows in-between existing
rows, try this quick play using a helper col

With data assumed running in row 1 down, insert a new col B,
Put in B1: =MOD(ROWS($1:1)-1,4)
Copy B1 down to the last row of data. Then select all cols in your range,
sort by col B, ascending. That should return the desired results. Delete col
B to clean up.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rgodchaux" wrote:
I need to copy 3 blank rows and insert them in every other row on the sheet.
Is there a way to insert multiple copied cells into multiple locations at one
time? Excel gives me the command cannot be performed with multiple
selections please select a single range error.

That formula did not do anything.

But if the row is blank, there's no need to copy it, just insert?? No
because.......
There are no exisiting blank cells on the sheet. I have to copy three blank
rows at a time so that it inserts three blank rows at once. I don't want to
have to hit insert three times below each rows.

I have rows with 8 colums of text (A-H) and I need to place 3 blank rows in
between each row of text. There are 200+ rows of text that I have to insert
3 rows between each and when I tried to insert copied rows into multiple
location at one time it said I couldn't. I am trying to consolidate my time
by doing an insert one time for the entire sheet.

"Max" wrote:

.. need to copy 3 blank rows and insert them
But if the row is blank, there's no need to copy it, just insert??

Presuming you meant that you want to insert 3 blank rows in-between existing
rows, try this quick play using a helper col

With data assumed running in row 1 down, insert a new col B,
Put in B1: =MOD(ROWS($1:1)-1,4)
Copy B1 down to the last row of data. Then select all cols in your range,
sort by col B, ascending. That should return the desired results. Delete col
B to clean up.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rgodchaux" wrote:
I need to copy 3 blank rows and insert them in every other row on the sheet.
Is there a way to insert multiple copied cells into multiple locations at one
time? Excel gives me the command cannot be performed with multiple
selections please select a single range error.

In your other post to the other newsgroup you stated you wanted to insert "every
other row"

Which is it? Insert between each row or every other row?

I posted a macro which you can change to every row by changing the

Step -2 to -1


Gord Dibben MS Excel MVP

On Wed, 5 Mar 2008 15:54:00 -0800, rgodchaux
wrote:

That formula did not do anything.

But if the row is blank, there's no need to copy it, just insert?? No
because.......
There are no exisiting blank cells on the sheet. I have to copy three blank
rows at a time so that it inserts three blank rows at once. I don't want to
have to hit insert three times below each rows.

I have rows with 8 colums of text (A-H) and I need to place 3 blank rows in
between each row of text. There are 200+ rows of text that I have to insert
3 rows between each and when I tried to insert copied rows into multiple
location at one time it said I couldn't. I am trying to consolidate my time
by doing an insert one time for the entire sheet.

"Max" wrote:

.. need to copy 3 blank rows and insert them
But if the row is blank, there's no need to copy it, just insert??

Presuming you meant that you want to insert 3 blank rows in-between existing
rows, try this quick play using a helper col

With data assumed running in row 1 down, insert a new col B,
Put in B1: =MOD(ROWS($1:1)-1,4)
Copy B1 down to the last row of data. Then select all cols in your range,
sort by col B, ascending. That should return the desired results. Delete col
B to clean up.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rgodchaux" wrote:
I need to copy 3 blank rows and insert them in every other row on the sheet.
Is there a way to insert multiple copied cells into multiple locations at one
time? Excel gives me the command cannot be performed with multiple
selections please select a single range error.