How to do Conditional Formatting using VBA in Microsoft Excel

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...

Adjust row height of merged cells using VBA in Microsoft Excel

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...

Set up conditional formatting for an area using VBA in Microsoft Excel

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...

Format data with custom number formats using VBA in Microsoft Excel

  In this article, we will create a macro to format the given data in the desired custom number format using VBA. Raw data for this example con...

Terms and Conditions of use

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.