VBA – Listing all procedures in all modules
Sometimes you need to unite two projects into one in VBA. In these two projects, if you …
Sometimes you need to unite two projects into one in VBA. In these two projects, if you …
Sometimes we have an excel file, where we want to highlight anything, matching a given cell. …
Wikipedia says that the activity selection problem is a combinatorial optimization problem concerning the selection of non-conflicting activities to perform within a given time …
Sumifs() and Countifs() are formulas in Excel, that sum or count a range with multiple conditions. …
Excel – Use Sumproduct() instead of Sumifs() or Countifs() Read more →
In Excel, there are plenty of ways to calculate the differences between days. However, the NetworkDays …
Comparing the speed of VBA and C++ in general is quite not fair. Its like comparing …
VBA vs C++ function – which one is faster in Excel? Read more →
After adding a c# library to VBA I have decided to take a look how to do …
Sometimes with Excel you receive an error message, saying “Too Many Different Cell Formats”. This is …
Yes, it exists! Today, I somehow managed to install it from here. This is how it …
In the current article, I show why it is convenient to use the Format as Table …
Simple Excel – Usage of column names for formulas Read more →