+ Reply to Thread
Results 1 to 4 of 4

automatically insert blank row between data according to value

  1. #1
    Registered User
    Join Date
    06-24-2009
    Location
    Dubai
    MS-Off Ver
    Windows Vista
    Posts
    2

    Question automatically insert blank row between data according to value

    Hi all,

    I would like to create a macro to automatically insert a blank row between data when the value in column D changes.
    Fe. the 1st 100 rows column D has value 'G', but in row 101 the value in column D changes to 'H' for the next 120 rows ..

    What formula do I need to write in my macro in order for excel to automatically insert a blank row every time the value in column D changes.

    Thank you.

    Jeroen

  2. #2
    Forum Contributor
    Join Date
    03-25-2008
    MS-Off Ver
    Excel, Outlook, Word 2007/2003
    Posts
    245

    Re: automatically insert blank row between data according to value

    Please Login or Register  to view this content.
    Charlize

  3. #3
    Registered User
    Join Date
    06-24-2009
    Location
    Dubai
    MS-Off Ver
    Windows Vista
    Posts
    2

    Re: automatically insert blank row between data according to value

    Thank you Charlize.
    One problem keeping me from executing the macro: I keep on getting an error message '424', object required. Please help.
    J.
    Attached Images Attached Images

  4. #4
    Forum Contributor
    Join Date
    03-25-2008
    MS-Off Ver
    Excel, Outlook, Word 2007/2003
    Posts
    245

    Re: automatically insert blank row between data according to value

    That's because it's worksheet code. Doubleclick on sheet 1 in the vba editor and select on the two comboboxes on top of your screen. Left one worksheet and right one the action of the worksheet. The code in between Private Sub Worksheet_Change ... and End Sub needs to be pasted in the correct event of the worksheet.

    Charlize

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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