+ Reply to Thread
Results 1 to 3 of 3

HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST?

  1. #1
    Phil A.
    Guest

    HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST?

    I have a standard list in Excel and I want to insert multiple alternate
    blank rows automatically so that these rows can be used for additiional data
    at a later stage.

    Can anyone offer advice as to how this can be done?

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    02-17-2005
    Posts
    22
    Hi

    I don't know how it can be done, but you might like to consider an alternative method of entering the extra data in columns alongside the respective rows - this way your data is future proof against ever needing to handle it as some sort of database - there have been a lot of posts lately that demonstate how difficult single columns of mixed but related data are to split into separate records should you ever need to do so.

    Julia

  3. #3
    Gord Dibben
    Guest

    Re: HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST?

    Phil

    "Automatic" requires VBA code.

    Sub InsertALTrows()
    'David McRitchie, misc 2001-06-30
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Dim i As Integer
    For i = Selection(Selection.Count).Row To Selection(1).Row + 1 Step -1
    Rows(i).EntireRow.Insert
    Next i
    Application.Calculation = xlCalculationAutomatic
    Application.ScreenUpdating = True
    End Sub

    If not familiar with VBA and macros, see David McRitchie's site for more on
    "getting started".

    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    In the meantime..........

    To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

    Hit CRTL + R to open Project Explorer.

    Find your workbook/project and select it.

    Right-click and Insert>Module. Paste the above code in there. Save the
    workbook and hit ALT + Q to return to your workbook.

    Run the macro by going to Tool>Macro>Macros.


    Gord Dibben Excel MVP



    On Tue, 19 Apr 2005 06:55:03 -0700, "Phil A." <Phil
    [email protected]> wrote:

    >I have a standard list in Excel and I want to insert multiple alternate
    >blank rows automatically so that these rows can be used for additiional data
    >at a later stage.
    >
    >Can anyone offer advice as to how this can be done?
    >
    >Thanks in advance.



+ 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