Which method do you use for sending an Excel file as a PDF via E-Mail? Go to Home –> Export –> Create PDF/XPS, then choose the folder and press “Publish”? Or do you go to Outlook, create a new E-Mail, search for the PDF file on your hard drive and attach it? There is a much faster way with just one click!
With VBA macros, you can do many things which aren’t possible using the build in Excel functions. You can save a lot of time by using macros, especially with repeating tasks.