+ Reply to Thread
Results 1 to 3 of 3

Template prints twice when running vba code

  1. #1
    Registered User
    Join Date
    12-21-2018
    Location
    Piarco, Trinidad
    MS-Off Ver
    2016
    Posts
    8

    Template prints twice when running vba code

    I posted this yesterday but I am not seeing the post?

    I have the following code. When I runs, it prints the template twice. Can anyone help me debug?

    Please Login or Register  to view this content.
    B2 Count the amount of Records. Currently, it has 5
    B4 the user select from which record to print from. Currently set to 1
    Using these values I should only get 1 print but the sheet is printing twice.

  2. #2
    Registered User
    Join Date
    12-21-2018
    Location
    Piarco, Trinidad
    MS-Off Ver
    2016
    Posts
    8

    Re: Template prints twice when running vba code

    I tried this but it still doesn't work

    Please Login or Register  to view this content.
    Last edited by admat; 10-19-2019 at 10:14 AM.

  3. #3
    Registered User
    Join Date
    12-21-2018
    Location
    Piarco, Trinidad
    MS-Off Ver
    2016
    Posts
    8

    Re: Template prints twice when running vba code

    After alot of searching, this post 79535-printing-vba-code-select-printer helped.

    I changed
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    which stopped the first page from printing twice.

+ 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. code works running in visual basic editor but not when running from Excel macro
    By smporco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2016, 05:44 PM
  2. Modification of a code that Prints all Pivot Filters
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2015, 12:35 PM
  3. [SOLVED] How to prevent worksheet code from running while Module Macro is running:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 09:26 AM
  4. Prints fine from VBE but not when code runs
    By ThumbsUp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2014, 03:26 PM
  5. ERROR while Running Macro from Template
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2010, 10:16 AM
  6. Template Running from Start-Up folder
    By AJSchwayze in forum Excel General
    Replies: 1
    Last Post: 11-20-2009, 06:54 PM
  7. [SOLVED] Template for Excel to keep running record?
    By Will Sutton in forum Excel General
    Replies: 0
    Last Post: 06-28-2005, 06:05 PM

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