Vba code to print excel sheet to pdf

See below: Sheet5. DalvinCentury DalvinCentury 1. New contributor. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. I have a free software called PDFLite and installs on my computer as a printer.

Worksheets "Rental". Range "A1:N24". ExportAsFixedFormat … Reviews: 5. Use the following code in your macro to save your file as PDF. Here is more information. For the past few years I've used Office , and with it, a particular VBA for Excel script which would print a worksheet to PDF, while scaling to fit all columns to a single page wide.

DoEvents Loop Until …. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Microsoft Localization. Microsoft PnP.

Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Microsoft Business. Microsoft Enterprise. Google serves cookies to analyse traffic to this site. Information about your use of our site is shared with Google for that purpose.

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Toggle navigation. Great code btw, as a complete novice I could import it and customize it to me needs! Leave a Reply Cancel reply Your email address will not be published. Continue No Comments. Continue 7 Comments. Continue 2 Comments. Continue 1 Comment. Terms and Conditions of use. Home About Advertise With Us.