Inserting Blank Lines

Hello all. I need some help and hope someone out there can assist me.

I have a spreadsheet with 100 or so lines with serveral columns going across. I want to insert a blank line in between each line that contains data. Is this possible?

Thank you for your help.
LPM

Sub insert_rows()
For r = 2 To 100 Step 2
Cells(r, 1).EntireRow.Insert
Next
End Sub

This will add a space between each starting at row 2 and ending at row 100.
Bear in mind that if you have 100 rows of data, the row range needs to be
200.
--
Ian
--
"LPM" <[email protected]> wrote in message
news:[email protected]...
>
> Hello all. I need some help and hope someone out there can assist me.
>
> I have a spreadsheet with 100 or so lines with serveral columns going
> across. I want to insert a blank line in between each line that
> contains data. Is this possible?
>
> Thank you for your help.
> LPM
>
>
> --
> LPM
> ------------------------------------------------------------------------
> LPM's Profile:
> http://www.excelforum.com/member.php...o&userid=27203
> View this thread: http://www.excelforum.com/showthread...hreadid=467165
>

Paul,
It did not work..... it says, " CANNOT USE THAT COMMAND ON OVERLAPPING SLECTIONS.... Any ideas?

Originally Posted by Paul Sheppard

Hi LPM

Select row 1, hold down the CTRL key select row 2, continue to the end until row 99 is selected, then right click and click on insert, a row will be inserted between each data row

If this is just a cosmetic thing, could you acheive the desire results by
selecting all rows and doubling their height? Inserting blank rows makes any
filtering, sorting, etc. soooo much harder (if not impossible), I'd avoid it
unless necessary.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"LPM" <[email protected]> wrote in message
news:[email protected]...
>
> Hello all. I need some help and hope someone out there can assist me.
>
> I have a spreadsheet with 100 or so lines with serveral columns going
> across. I want to insert a blank line in between each line that
> contains data. Is this possible?
>
> Thank you for your help.
> LPM
>
>
> --
> LPM
> ------------------------------------------------------------------------
> LPM's Profile:
> http://www.excelforum.com/member.php...o&userid=27203
> View this thread: http://www.excelforum.com/showthread...hreadid=467165
>

People do keep data in Excel and you won't stop the practice, so if you
can't be constructive, just keep out!

--
Ian
--
<[email protected]> wrote in message
news:[email protected]...
> yeah.. if you kept your DATA in a DATABASE this would be a lot easier
> in an access report
>

Never feed a troll...

Just add it to your killfile.

In article <[email protected]>, "Ian" <[email protected]>
wrote:

> People do keep data in Excel and you won't stop the practice, so if you
> can't be constructive, just keep out!

Normally I would. This one just got to me, I'm afraid :-(

I promise I'll try not to do it again :-)

--
Ian
--
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Never feed a troll...
>
> Just add it to your killfile.
>
> In article <[email protected]>, "Ian" <[email protected]>
> wrote:
>
>> People do keep data in Excel and you won't stop the practice, so if you
>> can't be constructive, just keep out!