+ Reply to Thread
Results 1 to 2 of 2

Add a blank row after the loop done the work and run the loop from the next row

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Add a blank row after the loop done the work and run the loop from the next row

    Hi guys,

    I have this excel file and I can't delimiter the comments. Sometimes i have 3 or 5 comments and i need a blank row to delimiter the 2 rows.
    Basically I am doing a comparison and I need to delimiter the comments from the next row from the loop.

    Please let me know if i can be more clear.
    Last edited by IonutC; 12-15-2016 at 01:20 PM.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Add a blank row after the loop done the work and run the loop from the next row

    Apologies, Im not fully sure what you mean, can you upload a basic sample sheet showing the original data and then some examples of what it should look like?
    If someone has helped you then please add to their Reputation

+ 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. Cannot get loop to work
    By JamesDunn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2015, 02:29 PM
  2. [SOLVED] Cannot get loop within a loop to work
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2015, 10:02 AM
  3. For loop to only work once then exit
    By JDodger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2014, 03:29 PM
  4. Loop Across Columns...If Blank Cell, Loop Down Rows
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2014, 07:05 PM
  5. Loop Across Columns If Blank Cell Loop Down Rows
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 10:22 AM
  6. [SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)
    By nixon72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2013, 12:46 PM
  7. Blank Validation Loop within Loop
    By vbhal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2011, 10:54 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