Power BI | DAX | Excel | VBA | Python | SQL

  • All Posts
  • DAX
  • CALCULATE
  • Power BI
  • DAX Studio
  • Tabular Editor
  • Running Totals
  • Visualization
  • Power BI Service
  • DAX Optimizations
  • Power Query
  • M
  • Circular Dependency
  • SQL
  • About Me
  • DAX Functions
  • VBA
  • Excel
  • Tableau
Search
SUM Cells by Color in Excel with VBA
Antriksh Sharma
  • Jul 5, 2021
  • 1 min

SUM Cells by Color in Excel with VBA

In this tutorial lets see how we can SUM cells in Excel with similar colors with the help of VBA. The dataset we are going to use: Now go...
340
Option Private Module in VBA - Prevent users from accessing sub-routine or functions.
Antriksh Sharma
  • May 26, 2021
  • 1 min

Option Private Module in VBA - Prevent users from accessing sub-routine or functions.

VBA allows you to create sub-routines or functions that can be hidden from the end user using only Excel interface, but sometimes that...
1012
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.