Create Drop down list in Excel. It is also called Data Validation list which allows users to enter only predefined values. VBA data Validation list also.
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.
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… [Continue Reading]
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.
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.
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… [Continue Reading]
Get Excel VBA Print macro code, that can also set print area, page layout etc., This Excel vba print command is more useful to automate printing of reports.