Excel VBA

How to Stop Formulas Auto Calculation in Excel

Normally we often use auto calculation in excel to do sum or other formulas for convenient. But sometimes we want to stop this after several calculations. In below article you will have two ways to stop the auto calculation. The first way is stop auto calculation by formulas options in Excel directly. The other way… read more »

How to Insert Cell Content into Header or Footer in Excel

This post will guide you how to insert the contents of a paricular into the header or footer cell in your active worksheet in Excel. How do I put a cell value into header or footer in all worksheets in your active workbook using VBA Macro in Excel. Insert cell Content into Header or Footer… read more »

How To Convert Text Case into Uppercase or Lowercase in Excel

This article will introduce two ways to change test case in Excel. You can perform UPPER\LOWER\PROPER functions to convert text into uppercase or lowercase letters in Excel , and you can also use VBA macro to perform the task. Select one you like, and let me show you the methods. You may meet the situation… read more »

How to Filter Formula in Excel

This post will guide you how to filter your data with an Formula in Excel. How do I filter cells with formulas through a User defined function in Excel 2013/2016. Filter Formula Assuming that you have a list of data in range B1:B5, in which contain some text values and formulas. and you want only… read more »

How to Insert a comment into Multiple Cells in Excel

This post will guide you how to insert a comment into two or multiple cells in Excel. How do I add comment to multiple cells with VBA Macro in Excel 2013/2016. Insert Comment into Multiple Cells Assuming that you have a list of data in range B1:B5, in which contain some text values, and you… read more »

How to Select Only Cells with Data in Excel

This post will guide you how to select all cells with data in Excel. How do I select only cells with data using VBA Macro in Excel 2013/2016. Select Only Cells with Data Assuming that you have a list of data in range A1:B5, in which contain text values and blank cells, and you want… read more »

How to Count Cells by Font Color in Excel

This post will guide you how to count cells by font color in Excel. How do I Count the number of cells with specific cell Font color by using a User Defined function in Excel. Count Cells by Font Color Assuming that you have a list of data in range B1:B9, in which contain some… read more »

Sidebar