+ Reply to Thread
Results 1 to 4 of 4

Insert A Blank Row When Column Value Changes

  1. #1
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    Insert A Blank Row When Column Value Changes

    Hi,

    I have a scores column "F" which every so often changes value.


    How do i add a blank row every time a value changes in a range in VBA?


    Here is what i have in column "F" and what im trying to achieve using VBA in Column "J";



    Insert Blank Row After Change_Forum.jpg


    Much appreciate

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Insert A Blank Row When Column Value Changes

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    Re: Insert A Blank Row When Column Value Changes

    Brilliant!

    Thanks so much Fluff13, sorry for the late response. That works great and has saved so much time.

    Rep left

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Insert A Blank Row When Column Value Changes

    You're welcome & thanks for the feedback

+ 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] Can't Insert Column Due to Non Blank Cells
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2015, 02:56 PM
  2. [SOLVED] Automatically insert a blank row below each row that has a value in a certain column
    By swood15 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2014, 10:52 AM
  3. Replies: 13
    Last Post: 09-19-2013, 06:54 PM
  4. Insert blank row based on Column value
    By srk121 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-29-2013, 08:20 AM
  5. [SOLVED] Compare 4 column values then insert a 5th columns value to a blank column/cell value
    By JasonKMcCoy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2012, 06:01 PM
  6. insert a blank column if a cell is blank...how?
    By bego in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2007, 03:04 AM
  7. [SOLVED] insert a blank row after data changes in a column
    By cyndi in forum Excel General
    Replies: 2
    Last Post: 10-24-2005, 10:05 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