+ Reply to Thread
Results 1 to 6 of 6

Print with macro Excel w/ sequence number

  1. #1
    Registered User
    Join Date
    09-21-2020
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    8

    Lightbulb Print with macro Excel w/ sequence number

    Hello,

    I want to create a macro to print label for parcels management.

    So I want the user to put the number of boxes (X), then Excel will print X times and on each label we'll see Box 1 of X.

    I've found this code: I can't post the link, the title of the article "Sequentially numbering multiple copies of single document using a macro" by Doug Robbins

    Can you help me with this problem.

    Thanks,

    Oli641
    Last edited by Oli641; 09-22-2020 at 07:45 PM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Print with macro Excel w/ sequence number

    Hi there,

    Here's a cheap 'n' cheerful approach which might get you moving in the right direction.

    Take a look at the attached workbook and see if it does what you need. It uses the following code:

    Please Login or Register  to view this content.
    The above code assumes that each label is printed on a single sheet. If you're using (e.g. 3 x 6) label sheets, the above code and the layout of the "Labels" worksheet will need to be altered accordingly. Let me know if you need any assistance with that.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-21-2020
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Print with macro Excel w/ sequence number

    Hi,

    I've tried to incorporate the code in my workbook.

    Here's the attached file.

    I want the user to put all the informations in the "search" sheet and to print the "Printing" sheet.

    But an error code happen.

    Please Login or Register  to view this content.
    Thanks,

    -Oli641
    Attached Files Attached Files
    Last edited by Oli641; 09-22-2020 at 03:26 PM.

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Print with macro Excel w/ sequence number

    Hi again,

    Take a look at the attached version of your workbook and see if it does what you need. The main changes relate to the defined Named Ranges in the workbook, and the additional rows in the "Printing" worksheet.

    The original code has been amended only slightly as follows:

    Please Login or Register  to view this content.

    Hope this helps - as before, please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files
    Last edited by Greg M; 09-22-2020 at 06:32 PM.

  5. #5
    Registered User
    Join Date
    09-21-2020
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Print with macro Excel w/ sequence number

    Hi,

    Thanks for your help! It's exactly what I need.

    Best regards,

    -Oli641

  6. #6
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Print with macro Excel w/ sequence number

    Hi again,

    Many thanks for your feedback.

    You're welcome - glad I was able to help.

    Regards,

    Greg M

+ 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. Macro for Number Sequence
    By Rj13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2019, 05:55 AM
  2. Macro to find and print gaps in a number sequence
    By jheidens in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2018, 09:15 AM
  3. need to print a sequence of numbers on excel 2013
    By eltyar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2016, 02:32 PM
  4. Replies: 7
    Last Post: 06-08-2015, 08:39 AM
  5. Macro sequence number
    By onenessboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2012, 02:46 PM
  6. Excel 2007 : print number sequence on 2 part ncr paper
    By quinterod in forum Excel General
    Replies: 1
    Last Post: 03-31-2011, 10:35 AM
  7. [SOLVED] How do I set a macro to print variable number of pages in excel?
    By Livio in forum Excel General
    Replies: 1
    Last Post: 07-29-2005, 08: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