+ Reply to Thread
Results 1 to 4 of 4

Nameless tables of different sizes need 20 rows inserted between oneanother

  1. 06-10-2014, 03:53 AM #1
    tessawanders
    tessawanders is offline
    Registered User
    Join Date
    06-09-2014
    Location
    Nairobi, Kenya
    MS-Off Ver
    2010
    Posts
    12

    Nameless tables of different sizes need 20 rows inserted between oneanother

    Hi everyone,

    I have a file with a lot of tables of different sizes. The table ranges have not been named.
    I would like to use a macro to insert 20 blank rows between each of them. What would be the easiest way to do this?
    Hope you can help me!

    Thanks a million
    Reply With QuoteRegister To Reply
  2. 06-10-2014, 03:58 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Nameless tables of different sizes need 20 rows inserted between oneanother

    You get better help on your question if you add an excel file, without confidential information.

    Please also add the desired result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 06-10-2014, 04:10 AM #3
    tessawanders
    tessawanders is offline
    Registered User
    Join Date
    06-09-2014
    Location
    Nairobi, Kenya
    MS-Off Ver
    2010
    Posts
    12

    Re: Nameless tables of different sizes need 20 rows inserted between oneanother

    Thanks for the tip oeldele. As you can see in the attachment all the tables just have 1 row (sometimes 2) separating them. I would like that to be 20.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-13-2014, 05:44 AM #4
    tessawanders
    tessawanders is offline
    Registered User
    Join Date
    06-09-2014
    Location
    Nairobi, Kenya
    MS-Off Ver
    2010
    Posts
    12

    Re: Nameless tables of different sizes need 20 rows inserted between oneanother

    I have reformulated this post: http://www.excelforum.com/excel-prog...ml#post3731742
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] function to multiply and sum multiple rows of various sizes down page
    By LittleTinGod in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-18-2013, 12:27 PM
  2. Macro: Copy 3 Rows & Insert below with Format....Also hide last two rows inserted
    By AWiT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 12:04 PM
  3. Making Tab Sizes smaller or creating multiple rows of tabs.
    By kingbiscuit in forum Excel General
    Replies: 4
    Last Post: 03-05-2008, 04:44 PM
  4. [SOLVED] How to get 2 tables (one below the other) with different sizes?
    By Carmen in forum Excel General
    Replies: 3
    Last Post: 07-08-2006, 10:25 AM
  5. How do I keep file sizes small when using multiple pivot tables?
    By jester1072 in forum Excel General
    Replies: 2
    Last Post: 06-06-2005, 02:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1