Insert Blank rows by VBA

Posted on 2012-08-16
Last Modified: 2012-08-16
Dear Experts:

I wonder whether it is possible ...
... to insert a blank row after each datarecord of the only table in the active document.

Hence: every other row is either a data record or a blank row.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Question by:AndreasHermle
    LVL 76

    Accepted Solution

    Hi Andreas,

    Unusually for you, your question isn't entirely clear.

    In VBA, you can insert a table row before a given row. By defat, the row is added at the end of the table.

    If you are doing a Directory-type of Mail Merge to a table, you can add an empty table row in the Main document. You will then get a blank row for each DataSource record in the output.

    Author Closing Comment

    Hi Graham,

    thank you very much for the insight into this matter.

    As always, professional support. Thank you very much.
    LVL 76

    Expert Comment

    Thanks Andreas.

    Actually,  I was a bit disappointed that I  couldn't be more help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    There is a feature provided by MS Word that lets you create an Table of Contents for your Word document automatically. To use this feature for other documents there are two steps involved,   1.  Prepare your document for a table of contents (he…
    This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
    This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now