Results 1 to 8 of 8

Keep printing until all values in a column is printed out - Macro

Threaded View

itsmejan24 Keep printing until all... 04-09-2012, 12:04 PM
Kelshaer Re: Keep printing until all... 04-09-2012, 01:35 PM
Leith Ross Re: Keep printing until all... 04-09-2012, 02:02 PM
itsmejan24 Re: Keep printing until all... 04-10-2012, 11:58 AM
Leith Ross Re: Keep printing until all... 04-10-2012, 01:10 PM
itsmejan24 Re: Keep printing until all... 04-10-2012, 10:09 AM
Kelshaer Re: Keep printing until all... 04-10-2012, 10:29 AM
Kelshaer Re: Keep printing until all... 04-10-2012, 01:12 PM
  1. #8
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Keep printing until all values in a column is printed out - Macro

    Try this
    Sub Print10s()
    Dim sh1 As Worksheet, sh2 As Worksheet
    Dim i As Long, r As Long
    Set sh1 = ThisWorkbook.ActiveSheet
    Set sh2 = ThisWorkbook.Worksheets("Sheet2")
    r = sh1.Range("A" & sh1.Rows.Count).End(xlUp).Row
    Dim c As Byte
    sh1.PageSetup.PrintArea = "A1:B20"
    With sh2
        .Range("A1:B20").Value = ""
        Do While i < r
            For c = 1 To 20 Step 2
                i = i + 1
                .Range("A" & c & ":B" & c).Value = sh1.Range("A" & i).Value
            Next
            sh2.PrintOut
        Loop
    End With
    End Sub
    Last edited by Kelshaer; 04-10-2012 at 01:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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