+ Reply to Thread
Results 1 to 2 of 2

Precise Printing with VBA

  1. #1
    Registered User
    Join Date
    05-23-2019
    Location
    Aurora, OH
    MS-Off Ver
    Office 16
    Posts
    1

    Precise Printing with VBA

    Hello -
    I am trying to get this worksheet to replicate itself, which works. However, I want it to print a certain number of copies based on the value in cell F2.
    Yet when I run the macro the only thing that works is the division macro that is within this Copy() macro.

    Sub Copy()

    Dim x As Long
    Call div

    For x = 1 To i
    With Worksheets("IP")

    Worksheets("IP").PrintOut Copies:=Range("F2").Value

    End With
    Next x

    End Sub

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: Precise Printing with VBA

    Hallo tryingtolearnExcel_1

    Welcome to the forum...
    Step 1 is....Read the Forum rules here...

    Your post does not comply with Rule #2
    2. Programming code must be enclosed in code tags to improve readability. (A, Z)
    Please Login or Register  to view this content.
    (or use the # button)
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

+ 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. What function should be used to give a precise value.
    By thanhvanchi in forum Excel General
    Replies: 2
    Last Post: 12-08-2016, 06:26 AM
  2. Keeping a currency precise
    By Tall Tony in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2016, 03:40 PM
  3. Looking for a way to make Vlookup using 'TRUE' more precise
    By ebeardsw in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2013, 12:19 AM
  4. Looking for a precise value in a table (matrix) ???
    By Sokol in forum Excel General
    Replies: 2
    Last Post: 01-17-2011, 07:23 AM
  5. Precise Printing
    By LisaGreen in forum Excel General
    Replies: 1
    Last Post: 12-02-2007, 02:29 PM
  6. Capture Value at precise time
    By deano48 in forum Excel General
    Replies: 1
    Last Post: 07-08-2007, 06:39 PM
  7. Precise positioning of a graphic in Excel
    By fishbin in forum Excel General
    Replies: 4
    Last Post: 12-22-2005, 12:20 AM

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