Skip to content

Count By Color On Excel

csxavier edited this page Jul 25, 2020 · 2 revisions
  1. Open your Excel workbook and press Alt+F11 to open Visual Basic Editor (VBE).

  2. Right-click on your workbook name under "Project-VBAProject" in the right hand part of the screen, and then choose Insert > Module from the context menu.

  3. Add the following code to your worksheet: Code for Count By Color