+ Reply to Thread
Results 1 to 2 of 2

ODD occurence with looping macros

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Schenectady, NY
    MS-Off Ver
    Office 365
    Posts
    65

    ODD occurence with looping macros

    OK,
    I have a macro that allows the user to select a bunch of SSNOs, pop them into a form (which then populates with unique information), print, create a .pdf, then move onto the next SSNO in the list until it's finished.

    It seems to work perfect, but we just ran a large batch of SSNO's (776). The macro only printed 773 of them, and only created .pdfs for 689 of them. There isn't any pattern (such as the first 84 or the last 84), but rather seems to randomly skip the process.

    Any ideas?

    Here's my code:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    01-28-2014
    Location
    Schenectady, NY
    MS-Off Ver
    Office 365
    Posts
    65

    Re: ODD occurence with looping macros

    Anyone have any idea why the macro would work only sometimes?

+ 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. Replies: 2
    Last Post: 03-21-2012, 12:28 PM
  2. Looping macros to add text to beginning and end of a paragraph
    By shanew in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2009, 05:26 AM
  3. [SOLVED] Calling macros, looping function? Can this code be written more efficiently?
    By Punsterr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-07-2005, 03:05 PM
  4. Help needed - seriously (looping? macros? formulas?)
    By jarski in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2005, 01:05 PM
  5. [SOLVED] Looping macros using VB code
    By accessuser1308 in forum Excel General
    Replies: 2
    Last Post: 03-09-2005, 08:06 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