Instead of displaying Microsoft Excel, show something useful in your Excel title bar. Use the Application.Caption VBA property to display the exact time you opened your Excel workbook. A little VBA goes a long way toward making you and your Excel workbooks stand out.
We just added a 6th cheat sheet to our training bundle. With our new guide on VBA UserForms, our bundle now has over 200 tips like how to automate data extraction from text files, how to remove duplicates from an array, and how to dynamically populate a listbox.
This VBA macro prints each Chart and ChartObject in your Excel Workbook as a separate page. Prior to printing, the macro identifies the optimal page orientation and it counts the total number of submitted print jobs.
Save each page in your MS Word document as a separate PDF with this VBA macro. The flexible VBA script let’s you save each page or a subset range of pages as PDFs in a user-specified directory. Complete with robust error-checking.
Prevent your screen from updating until your Excel macro is finished with Application.ScreenUpdating=False. The Application.ScreenUpdating property is useful when running macros that jump from cell to cell, sheet to sheet, and workbook to workbook.
Outlook search not working? Use this VBA code example to search through your email inbox. This tutorial shows you how to regain search functionality if you are one of the thousands of people whose Outlook instant search function has stopped working.