+ Reply to Thread
Results 1 to 2 of 2

Inserting blank rows in Excel.

  1. #1
    kwm5321
    Guest

    Inserting blank rows in Excel.

    In Excel, is it possible to insert a 'blank' (new) row between each row of
    exisitng text?

  2. #2
    Chip Pearson
    Guest

    Re: Inserting blank rows in Excel.

    Try the following VBA macro:

    Sub InsertRows()
    Dim RowNdx As Long
    Dim LastRow As Long

    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    For RowNdx = LastRow To 2 Step -1
    Rows(RowNdx).Insert
    Next RowNdx

    End Sub


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


    "kwm5321" <kwm5321@discussions.microsoft.com> wrote in message
    news:38D30B68-D227-4FD3-B066-13B7F6EAE3FD@microsoft.com...
    > In Excel, is it possible to insert a 'blank' (new) row between
    > each row of
    > exisitng text?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1