Results 1 to 10 of 10

VBA Skipping lines of code.

Threaded View

  1. #3
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: VBA Skipping lines of code.

    Quote Originally Posted by TMS View Post
    Without data, it's difficult to know what is happening. Best guess is it's hitting the Exit For condition.
    Yep. I tested here on a 2 blank sheets. Removing the Exit fixes the issue.

    But you are doing ALOT of looping here. Each loop of r runs 315 times for n to finish.

    346,185 loops on that code !!
    Last edited by ptmuldoon; 02-15-2018 at 03:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is VBA skipping lines of code?
    By JonathanEngr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2018, 06:48 PM
  2. [SOLVED] Sub is skipping lines of code after Then statement
    By chavez982 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2012, 10:32 PM
  3. [SOLVED] How do I allow for skipping lines between dates??
    By n2music in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2012, 10:28 AM
  4. return results without skipping lines.
    By mjhopler in forum Excel General
    Replies: 2
    Last Post: 07-13-2010, 04:01 AM
  5. Copy a formula skipping lines
    By JapanDave in forum Excel General
    Replies: 3
    Last Post: 06-01-2010, 05:11 AM
  6. [SOLVED] Need help in numbering a column while skipping lines
    By Gary Reger in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2005, 06:10 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