How to type a subscript in Excel. Also learn to type a superscript for a part of text. This page also has macro code to convert a part of text in Excel to be subscript, superscript or strikethrough
Get Excel VBA code to convert Column Letter to number. The Formula & Excel vba code will get column alphabet letter & return the Column number as value.
Get Excel vba code & formula to convert column number to letter. Use this function in Excel worksheet or vba macro to get column letter from its column number.
Copy Active workbook or any workbook from external path using the inbuilt Excel function workbook.savecopyas. Make a Excel workbook copy to new path.
Get Excel VBA Convert a Range to Array code in a Excel Workbook. And also write the array value to a worksheet range. Learn how to use of Resize & Transpose functions.
How to create a drop down list in Excel? Also learn how to create/add data validation, change the selection in drop down or delete Validation list using the Excel Macro. It is a Drop down list complete guide for Excel users.
How to Automate Emails From Excel? Get macro to send email from Excel & email Excel file as attachment using VBA. In this page, you will learn and get code for 2 different things. Be it a professional Organization announcement, Promotional offer or a Valentine greeting email, these codes will… [Continue Reading]
Follow this method to send a mass email in Outlook by creating distribution list & also through VBA code. VBA code send mass email Outlook to all contacts.
Learn how to Import Xml to Excel.Get quick VBA codes that Convert XML to Excel file. It is also possible to import xml to Excel directly from website URL.