Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Macro to enable data to be printing on one page

    I have set up a macro to print the sheet called data, but cannot get it to print all the visible columns on one page. The rows can be printed on several pages I want to print in lanscape and fit all the columns on one page where the print size is not less than 60% if possible (I have hidden certiain columns so as to ebable me to do do)



    I need to print the unhidden columns up to Col Z

    I have attached some sample data

    Your assistance in this regard is most appreciated
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Setup the page for landscape in Excel view and narrow margins to keep print as large as possible. In the print screen (File>Print), select "Fit all columns on one page" or add this line to your print macro:

    .FitToPagesWide = 1

    Maud
    Last edited by Maudibe; 2013-06-08 at 02:48.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Maud

    Thanks for the help. I have added .FitToPagesWide = 1 to my macro "Print all" , but all the columns are not selected. The rows can print on several pages. The actual rows containing data are +- 500 rows.

    It will be appreciated if you will amend the code in my macro to print all the columns or give me the option to use Page break Preview in the macro to set the print range to include all the columns and then to print
    Attached Files Attached Files

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi Howard

    This should do it.
    see attached file.

    zeddy
    Attached Files Attached Files

  5. The Following User Says Thank You to zeddy For This Useful Post:

    HowardC (2013-06-08)

  6. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks for the help. This is exactly what I am looking for

    Regards

    Howard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •