how to set print area within macro
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: how to set print area within macro

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    For a varying size of report how to set print area within macro ?

  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    Plano, Texas
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try this...You will first need to define the name of your data range.

    rowcount = Range("Output").Rows.Count

    Sheets("Report").Select
    printrange = "A1:K" & rowcount
    Sheets("Report").PageSetup.printarea = printrange

    [ This Message was edited by: larry on 2002-04-05 13:31 ]

User Tag List

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
  •  

 

 
DMCA.com