portrait

  1. M

    Export a range to pdf

    Afternoon I am looking to export a number of ranges to one single PDF but one of the ranges is a variable range. The ranges I want to export are: A1:C12 A13:C26 A27:C38 A42:C72 A73:C95 G161: the last cell with a text in it located in Column K the file name is: thisworkbook.path & “Reports” &...
  2. D

    vba Export Excel to PDF. 2 pages. One Portrait, One landscape.

    Hello, if anyone knows how to do this, I would appreciate a pointer. There are a few threads on it but i havent found one that actually answers the question of how to do it as one PDF with different orientations per page. This is where i am at so far... Sub ExportPDF2() Dim sFile As String...
  3. W

    Printing Issue

    I have a worksheet where one macro creates a new worksheet from a pivot table and prints a copy for an employee's record. That print is in color and portrait even though the code says to print b&w and landscape. While also creating a new worksheet the code creates a button on the new worksheet...
  4. M

    Exporting as PDF in landscape format

    Hello everyone! I have a worksheet with 5 pages. One of them I want to export in landscape format. It's the third page. Here are the ranges: B1:K69 -> Portrait (Pages 1-2) B70:P115 -> Landscape (Page 3) B116:K215 -> Portrait (Pages 4-5) At moment, I can export it all as portrait using this...
  5. L

    Print selected Range one time but vertically(portrait)?

    Hello dear MrExcel! How to print selected range vertically, copies 1, colatte True, normal margins? Thanks in advance? Ps. I just don't know very well VBA, sorry for SELECT&SELECTION! Sub Macro1printanjestanja() ' ' Macro1printanjestanja Macro ' ' ' Range("M8:Q22").Select '...
  6. L

    Changing Orientation of pages

    Hi, I'm looking for a way to change the margins while changing the orientation of the page in Excel. When in portrait mode the margins need to be: Left/Right: 2,3; Top/Bottom: 3,6 and Header/Footer: 3,3 (cm). In Landscape it should be: Left/Right: 3,3; Top/Bottom: 2,3 and Header/Footer: 2 (cm)...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top