Antriksh SharmaJul 5, 20211 min readSUM Cells by Color in Excel with VBAIn 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...
Antriksh SharmaMay 26, 20211 min readOption 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...