1. P

    Excel PDF Macro Forcing First Page to be Portrait Mode?

    Hi - I am working on a macro that prints select sheets to a PDF output. For some reason, it will always print the first page in portrait mode even when I define in page setup to print it as landscape. If I put a page before it, that new first page will print as portrait and then my old "page 1"...
  2. 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” &...
  3. S

    printing userform landscape and on a4

    Hello all I want to print my userform on a4 in landscape. i have searched the web for answers, have found code also, but it just does not work for me. i cant really pull the data from the userform to a sheet either, well not easily, i have certian layout and tickboxes etc the code i have...
  4. 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...
  5. L

    Userform Print in Landscape

    Can anyone help, share idea, how to code VBA excel to page setup of userform and print userform in landscape.
  6. M

    ActiveSheet.ExportAsFixedFormat on a Mac not printing in landscape orientation

    Hi, Excel 2016. I am trying to send a PDF in landscape orientation by mail using the ActiveSheet.ExportAsFixedFormat function. If I try printing the sheet it manually it works fine in landscape. But it does not work in VBA. I have googled this issue extensively for no solution. Sub...
  7. A

    VBA to Print multiple worksheets with different print ranges

    I know enough to be able to parse and understand a VBA code once I see it but not enough to actually know how to write it from scratch. Really need some help here. So let me see if I can explain. Worksheet 1 print range a1:m36 worksheet set to landscape Worksheet 2 print range a1:m36 worksheet...
  8. M

    Email in body of outlook - landscape?

    I have some code which includes this; With ActiveSheet.MailEnvelope .Introduction = "" .Item.To = "email address" .Item.Subject = "subject" .Item.Send End With It works fine, however the data is quite wide so the email has to be manually set as Landscape to be able to print it...
  9. P

    PDF aspect ratio from SmartArt

    My Picture Org Chart created from Smart Art always starts as a square even though I set width to 1000 and height to 500. Then when I ExportAsFixedFormat to PDF it's still a square and too small. Does anyone know how to have the chart created with a landscape size and to have the PDF created also...
  10. A

    Print as PDF macro orientation

    Hi, i built a macro to print from several files and sheets as pdfs, which is working fine. However, I wanted to specify the page/print setup orientation (portrait vs. landscape). I was hoping the below would work by specifying the preferred orientation in column G (e.g cell G5 will say...
  11. G

    Change Default Printer Settings

    Hello, how can I change Excel's printer settings so that every time I open a new workbook, the settings to print are always set to Landscape and the scaling is always set to Fit All Columns on One Page? I'm using Excel 2010. Please help, thanks.
  12. B

    Simple way to print in landscape VBA

    Hello I am trying to print in an excel sheet in landscape mode and think that there has to be a simple way of doing this, but maybe not and I just need somebody to help me with the page setup: Here is the code that I have right now: sub PrintGMReport () Sheets ("General Manager...
  13. 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...
  14. B


    How to take multiple prints from multiple sheets by clicking command button? I want A20:F60 table From 20 sheets I want to take print with same range in A4 landscape Is there any macro for this?
  15. Tosborn

    Print to PDF VBA formatting issues

    Hi all, I have some VBA to print out a large document for all regional manager & their stores to one pdf file. I have set the page setup as landscape and fit to one page for each page but it doesn’t work when the pdf is created. Each page comes out as portrait and not on the one page. Any...
  16. F

    Hide Excel Title bar, maximize, minimize, close buttons

    I have been using API code similar to successfully to hide the Title Bar (min, max, close, menu buttons) in Excel 2013/2016 running Win 7/Win 10 and it has been working without issue on tablets when rotating...
  17. P

    code to print page 1 in landscape, and page 2 in portrait

    Hi, I have the following code to print page 1 of any worksheet with a 5-digit name For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.PrintOut from:=1, To:=1 End If Next ws However, is it possible to change this code (again for any sheet with a 5-digit name) to print...
  18. 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)...
  19. L

    Save as PDF with special function

    Dear Excel friends I hope there is a smart person out there who can help me with a small Macro (Excel 2010) – I have been in contact with a lot of friends in Denmark that normally work with excel, but nobody seems able to help me. Why I hope there is a "geek" in this forum that can help me...
  20. M

    export as fixedformat pdf - orientation can't get last sheet to landscape

    Hello all, I'm new here but I hope you can help me out. I've code to export multiple sheets in a workbook to pdf using 'ExportAsFixedFormat Type:=xlTypePDF' All sheets are set to landscape. The export works fine however most of the time the last sheet is orientated as portrait instead of...

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
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 "".
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