page setup
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: page setup

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

    Default

     
    I am trying to get two really long columns to print out on less pages, and I was wondering if it is possible to get the colums to go down and across the page (that is repeat the columns more than once per page) then go on to another page. So I would end up with maybe 6 columns on a page (my 2 columns, repeated 3 times) before it placed the data on the next page. Does anyone know how this can be done? Thanks in advance

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-02 09:49, minsoo wrote:
    I am trying to get two really long columns to print out on less pages, and I was wondering if it is possible to get the colums to go down and across the page (that is repeat the columns more than once per page) then go on to another page. So I would end up with maybe 6 columns on a page (my 2 columns, repeated 3 times) before it placed the data on the next page. Does anyone know how this can be done? Thanks in advance
    Quick way to do this is to use the camera
    tool and take a shot of the columns that
    you need (2) and paste side by side @ the
    top of your column data start.
    Then just set the print area to this range.


    Kind Regards,
    Ivan F Moala From the City of Sails

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