Results 1 to 9 of 9

Do While loop not breaking?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    112

    Do While loop not breaking?

    Hello

    Perhaps there is a better way to write my intentions, but I decided to write a Do...While loop in order to delete all the Steps (in rows) after #1. However, it is deleting more than it should, but it shouldn't be that way. Since I'm always checking whether the .Value <> "", it should immediately break if the value of the particular cell that I'm looking for is blank.

    However, the loop continues to delete one more row after that, so I'm confused why the conditional is not acting correctly. Any help in this would be greatly appreciated.

    The worksheet labeled "System_Template_Intention" is my intended action and the "System_Template_Result" is what I get after running the macro "DefaultReset"

    Thanks in advance for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto email loop with formatted table data breaking on second loop VBA
    By Who_else in forum Excel General
    Replies: 6
    Last Post: 03-24-2016, 06:22 AM
  2. Breaking loop if condition met
    By kaderk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2015, 11:09 AM
  3. [SOLVED] Find function in nested loop breaking down - not on first time through loop
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-14-2014, 09:32 AM
  4. Find function in nested loop breaking down - not on first time through loop
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 04:59 PM
  5. LOOP formula breaking
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-08-2012, 04:28 PM
  6. Breaking out of a loop
    By hojkoff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2010, 07:29 AM
  7. Breaking a Find Loop
    By Jmoo in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2010, 10:55 AM

Tags for this Thread

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