+ Reply to Thread
Results 1 to 3 of 3

Printing a Section on Several pages

  1. #1
    Registered User
    Join Date
    12-25-2004
    Posts
    2

    Printing a Section on Several pages

    I have the same portion of a spreadsheet in the same area on multiple pages in a workbook that I would like to PRINT. Since the workbook has mutiple pages (40+/-) I would like not to have to print the other portions on each sheet other than the specific area. Is there way to print this specific section and not print the other portion of the sheet w/out going from sheet to sheet of this workbook? Can it be automated?
    Thanks, Stormy

  2. #2
    Forum Contributor
    Join Date
    11-09-2004
    Posts
    451
    it will print all worksheets with range a1:j12




    for each w in worksheets
    sheets(w.name).select
    Range("A1:J12").Select
    ActiveSheet.PageSetup.PrintArea = "$A$1:$J$12"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
    next

  3. #3
    Registered User
    Join Date
    12-25-2004
    Posts
    2

    Thanks i will pursue this

    Thanks i will pursue this

+ Reply to Thread

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