I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.

This might suffice ..
Assume data is in rows 1 - 10 in cols A to C
Insert a new col A, fill A1:A10 with serials: 1,2,3... 10
Copy A1:A10 n paste the same serial nos into A11:A20
Select cols A to D, Click Data Sort Sort by Col A (ascending) OK
Clean up, delete col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"snarled times" wrote:
I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.

for i=cells(rows.count,"a").end(xlup).row to 2 step-1
rows(i).insert
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"snarled times" wrote in message
...
I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be
done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.

Don,
I am not this advanced, can you explain how I would do this? thanks

"Don Guillett" wrote:

for i=cells(rows.count,"a").end(xlup).row to 2 step-1
rows(i).insert
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"snarled times" wrote in message
...
I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be
done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"snarled times" wrote in message
...
Don,
I am not this advanced, can you explain how I would do this? thanks

"Don Guillett" wrote:

for i=cells(rows.count,"a").end(xlup).row to 2 step-1
rows(i).insert
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"snarled times" wrote in message
...
I have a worksheet - many rows of completed data - I need to insert a
blank
row between each of the rows with data (a few hundred). How can this
be
done
quickly? I tried the insert row and paste function - does not work
well. I
welcome the help to make this an easy thing to do.
thanks in advance.

I will now stick in my standard reply to this request.

Inserting a row between each row of data will make it very difficult to do any
type of sorting or filtering the data.

If just for visual appearance, better to double the row heights.


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 04:59:01 -0800, snarled times
wrote:

I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.