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...
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...
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...
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...
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...
In our previous articles, we have learned how to extract unique values from a range using a combination of different excel functions. Although the...
A Collection is a data type that holds stores objects just like arrays (but different). While writing basic VBA codes, you must have used Workbooks,...
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.
