Results 1 to 6 of 6

MACRO to Insert row in 'D' col after name changed.

Threaded View

  1. #1
    Forum Contributor visha_1984's Avatar
    Join Date
    11-27-2012
    Location
    Pune,India
    MS-Off Ver
    Excel 2013
    Posts
    309

    MACRO to Insert row in 'D' col after name changed.

    Hi,Team

    I need macro to insert blank row in D col after name changed for specific range or from specific row
    I have attached sample file, Below is macro code which is used for inserting blank row.

    Sub InsertBRow()
        Dim iRow    As Long
    
        iRow = 3
        Do
            With Cells(iRow, "D")
                If IsEmpty(.Value) Then Exit Do
                If .Offset(-1).Value <> .Value Then
                    .EntireRow.Insert
                    iRow = iRow + 2
                Else
                    iRow = iRow + 1
                End If
            End With
        Loop
    End Sub
    Thanks in advance
    Attached Files Attached Files
    Happy to Help

    VISHA

    Click *, if the suggestion helps you!
    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2007 : Insert DATE if any Cell in Row changed
    By varocketry in forum Excel General
    Replies: 4
    Last Post: 12-03-2012, 06:30 PM
  2. Insert new columns when the value in the column changed
    By mridzuani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2011, 04:14 AM
  3. Insert Formula if cell is changed from blank
    By buffalotom99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2009, 07:54 AM
  4. Insert date when adjacent cell changed
    By speakers_86 in forum Excel General
    Replies: 0
    Last Post: 10-02-2006, 02:54 PM
  5. [SOLVED] Insert function changed
    By EZDO Bob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-08-2005, 12: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