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 […]
This Tiny VBA Can Send Email to All contacts in Your Outlook
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 Code JavaScript in VBA
Learn how to execute a Javascript within a VBA Code? It is not that tough to code a Javascript within VBA and make it execute within Excel itself. All you just have to do is, reference Microsoft Script Control Library and start coding your Javascript or VBscript as explained in this page.
VBA Macro Import – Read XML File into Excel – 5 Easy Tips
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.
Pick Multiple Columns using Random Numbers in Excel
In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet. Now, we will see how to get values from Random Columns using the same function. This is kind of applying the Rand function little bit different application that we usually do. These […]
How To Subtract in Excel?
Select a worksheet, enter ‘=5-3’ in any cell and press Enter. Excel will calculate the difference and display result as 2. We have just entered a Formula in Cell that starts with ‘=’ sign. If we type anything in a worksheet starting with ‘=’ sign, Excel treats it as a formula, executes the formula and display the result only.
Search for Value in Table using Beyond Vlookup
Assuming Table Range is A1:E10 with numbers and need to search for a number, in this case ‘2’, then enter this Array Formula** to get the Row and Column number.
{=MIN(IF(A1:E10=2,ROW(A1:E10)))}
{=MIN(IF(A1:E10=2,COLUMN(A1:E10)))}
#N/A Error In Excel – Generate, Analyze & Exclude
Making of #N/A Error & Solve it If You are an Frequent MS Excel User, then you should have seen those Unexpected return codes from Formula that start with Hash(#). These are the Error Codes that those formula return when it could not process the Input Data or Invalid Data.This […]
How to do VLOOKUP?
Learn how to use VLOOKUP with simple example. VLOOKUP usage directly in Excel and within VBA Macro code. Get VBA code to use this function in Excel Automation. A Vlookup function search for ‘value to search’ in the first column of ‘table Range’ and then returns a value from the same row.
VBA Code – Create Index of Worksheets – with Links to each Sheet
Vba code to create list of worksheet names with hyperlinks. Once you create this Worksheet Index using vba code, it is easy to refer the sheets. Also display worksheet list tab with macro