+ Reply to Thread
Results 1 to 7 of 7

Use VBA code to insert 30 blank columns every 30 columns

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Use VBA code to insert 30 blank columns every 30 columns

    Is it possible to insert 30 blank columns using VBA code every 30 lines? I've resorted to doing it 720 times manually. and will have to do it gain.insert blank columns.xlsb

  2. #2
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Use VBA code to insert 30 blank columns every 30 columns

    Just incase someone is able to assist, please show me how I would alter it in the future to start from any column.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Use VBA code to insert 30 blank columns every 30 columns

    The column starts from the last column working back word to column 5

    Please Login or Register  to view this content.
    Last edited by AB33; 04-02-2014 at 02:13 PM.

  4. #4
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Use VBA code to insert 30 blank columns every 30 columns

    Thank you Soooooo much.

  5. #5
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Use VBA code to insert 30 blank columns every 30 columns

    Can I replace to the end with a specific column. Column TJ to be specific.

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Use VBA code to insert 30 blank columns every 30 columns

    If you mean from a fixed range to end.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Use VBA code to insert 30 blank columns every 30 columns

    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] insert alternate blank columns
    By kuntalnr in forum Excel General
    Replies: 1
    Last Post: 02-21-2014, 11:21 AM
  2. [SOLVED] Insert 50 blank columns inbetween
    By weidlh46 in forum Excel General
    Replies: 3
    Last Post: 12-30-2013, 03:06 PM
  3. Formula insert in blank columns
    By snorris2001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2012, 07:40 PM
  4. Macro code to insert Blank columns and rename them
    By robertguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2008, 09:02 AM
  5. Insert a blank Column Every 9 Columns
    By Nigel Bennett in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1