Results 1 to 2 of 2

Please help to set up print areas.

Threaded View

nikkoabc Please help to set up print... 02-02-2010, 05:05 PM
shg Re: Set up print areas? 02-02-2010, 05:07 PM
  1. #1
    Registered User
    Join Date
    10-30-2009
    Location
    Mississauga, Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Please help to set up print areas.

    Hi, Guys

    I have range A1:T32; range A33:T64; range A65:T96; range A97:A128; each time increasing 32 lines, until last range A321:T352, total 10 ranges. I want to print each range in one page, someone can help me to finish my VBA with loop? Thanks.
    Nikko

    [Code]

    Private Sub masco1()
    With Sheets("Sheet1")
    .PageSetup.PrintArea = "$A$1:$T$32" &

    End Sub
    Last edited by nikkoabc; 02-02-2010 at 09:00 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