Let's paint a Monalisa painting and leave Picasso behind using VBA. Ready, Get Set … Wait! Wait! Hold your horses. We are just going to use VBA t...
Many a times, you have to copy data from an excel file to a word document. You can do this with a macro very easily. The macro will open a new / exi...
The two example macros below demonstrates how you can send information to Outlook (e.g. sending an e-mail message) and how you can retrieve informati...
There are times we have to copy data from a word document to an excel file. We can do this very easily with a macro in all version of office. Th...
Question: Merged cells do not have the correct height after a row break. How can I correct this? Answer: Insert the following code in the standar...
In this article, we will create a macro to apply conditional formatting in the selected area. We have used random numbers as sample data to demonstra...
Excel Add-Ins An Excel Add-In is a file (usually with an .xla or .xlam extension) that Excel can load when it starts up. The file contain...
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.
