Results 1 to 2 of 2

Thread: code to printout 2 copies not 1
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2016
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default code to printout 2 copies not 1

    Hello, I use this line in my code to printout copies of sheet3, I need it to print 2 copies, not just 1? any help would be greatly appreciated. I am sure it is very easy change to this line, but I cant get it to work.

    Code:
    Sheet3.Range("A1:I20").PrintOut
                Next
            Next
        End With

  2. #2
    Board Regular
    Join Date
    Sep 2016
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: code to printout 2 copies not 1

    [QUOTE=steve400243;5287570]Hello, I use this line in my code to printout copies of sheet3, I need it to print 2 copies, not just 1? any help would be greatly appreciated. I am sure it is very easy change to this line, but I cant get it to work.

    [CODE]Sheet3.Range("A1:I20").PrintOut
    Next
    Next
    End With

    Never mind all - I was able to figure this out with a simple addition of "printout copies:=2"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •