+ Reply to Thread
Results 1 to 4 of 4

Insert 50 blank columns inbetween

Hybrid View

weidlh46 Insert 50 blank columns... 12-30-2013, 02:48 PM
Norie Re: Insert 50 blank columns... 12-30-2013, 02:54 PM
weidlh46 Re: Insert 50 blank columns... 12-30-2013, 02:59 PM
venkatpvc Re: Insert 50 blank columns... 12-30-2013, 03:06 PM
  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    Mineapolis, Minnesota, US
    MS-Off Ver
    Excel 2007
    Posts
    15

    Insert 50 blank columns inbetween

    Hi folks,

    I am trying to insert 50 blank columns in between each id. What methods should I use?

    Thanks very much.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Insert 50 blank columns inbetween

    Do you mean rows?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-19-2013
    Location
    Mineapolis, Minnesota, US
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Insert 50 blank columns inbetween

    Sorry, Yes, i mean rows.

  4. #4
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: Insert 50 blank columns inbetween

    if you are looking for vba code try this
    Sub myTest()
    Dim mycel As Range
    Dim lr As Long
        lr = Cells(Rows.Count, "g").End(xlUp).Row
        For i = lr To 9 Step -1
            If Cells(i, "g").Value > "" Then
                Cells(i + 1, "g").Resize(50, 1).EntireRow.Insert
            End If
        Next i
    End Sub
    Last edited by venkatpvc; 12-30-2013 at 03:09 PM.
    Give Feedback and Click(*)

+ 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. Formula insert in blank columns
    By snorris2001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2012, 07:40 PM
  2. VBA Extract Numbers only from Cell and Insert spaces Inbetween (Getnumbers)
    By jamieray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2012, 06:53 AM
  3. Replies: 8
    Last Post: 03-10-2010, 01:21 PM
  4. [SOLVED] 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
  5. Insert Blank Column every 9 Columns
    By Nigel Bennett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2005, 01:06 AM

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