Save Excel Range as PDF using VBA

To save a selected range in excel (say a receipt) as PDF in Excel using VBA use below syntax. The Generic Code Sub SaveRangeAsPDF() Range...

Custom Excel XLOOKUP Function

The XLOOKUP function is exclusive to the insider program of office 365. The LOOKUP function has many functionalities that overcome many of the weaknes...

How To Extract Domain Name from EMail in Excel

Well, we know that the domain name always comes after the @ sign in any email id. To extract domain name from email address we can use this fact. So t...

Transpose Column to Excel Sheets using VBA

Scenario Assume that you have an excel workbook. It has 3 sheets. A sheet contains 5 columns. Each column has a different city's data. Each sheet c...

3 Best Ways to Find Last non-blank Row and Column Using VBA

Finding last used row and column is one of the basic and important task for any automation in excel using VBA. For compiling sheets, workbooks and arr...

Send Bulk EMails From Excel VBA in One Click

Ever got a need to send email from excel VBA to multiple email ids, provided in an excel sheet? Want to learn how to send mails from Excel without ope...

VBA Class Modules and How to Use Them

What is a Class in VBA? A class is a blueprint for an object to be created. A class itself does nothing but using classes you can create multip...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube