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 code to Convert a Worksheet Range to Array. And also write the array value to a worksheet range. Learn use of Resize & Transpose functions.
Create Data Validation Drop Down List in Excel using VBA. Also get Code to change the value in selection & to delete the drop down validation list from a cell or entire worksheeet.
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.