↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Home › Posts tagged Excel › Page 8

Tag: Excel

VBA – Listing all procedures in all modules
VBA \ Excel

VBA – Listing all procedures in all modules

Vitosh Aug 11, 2017 Tagged with Excel, Listing all procedures in all modules, VBA, vbe

Sometimes you need to unite two projects into one in VBA. In these two projects, if you …

VBA – Listing all procedures in all modules Read more →

Excel VBA – Search and highlight text
VBA \ Excel

Excel VBA – Search and highlight text

Vitosh Jul 29, 2017 Tagged with Excel, search and highlight, substring search, VBA

Sometimes we have an excel file, where we want to highlight anything, matching a given cell. …

Excel VBA – Search and highlight text Read more →

Excel VBA – Activity Selection Algorithm
VBA \ Excel

Excel VBA – Activity Selection Algorithm

Vitosh Jul 17, 2017 Tagged with algorithm, Excel, greedy, VBA

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 …

Excel VBA – Activity Selection Algorithm Read more →

Excel – Use Sumproduct() instead of Sumifs() or Countifs()
VBA \ Excel

Excel – Use Sumproduct() instead of Sumifs() or Countifs()

Vitosh Jul 15, 2017 Tagged with closed workbook, Countif, Excel, Sumif, Sumifs, Sumproduct

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 →

Excel VBA – NetworkDays Formula
VBA \ Excel

Excel VBA – NetworkDays Formula

Vitosh Jul 14, 2017 Tagged with Excel, NetworkDays, VBA

In Excel, there are plenty of ways to calculate the differences between days. However, the NetworkDays …

Excel VBA – NetworkDays Formula Read more →

VBA vs C++ function – which one is faster in Excel?
C++, VBA \ Excel

VBA vs C++ function – which one is faster in Excel?

Vitosh Apr 25, 2017 Tagged with C#, custom c++ function, Excel, VBA

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 →

C++ – Adding C++ function to VBA/Excel
C++, VBA \ Excel

C++ – Adding C++ function to VBA/Excel

Vitosh Apr 24, 2017 Tagged with C#, dll, Excel, VBA

After adding a c# library to VBA I have decided to take a look how to do …

C++ – Adding C++ function to VBA/Excel Read more →

VBA – Too many different cell formats
VBA \ Excel

VBA – Too many different cell formats

Vitosh Nov 1, 2016 Tagged with Excel, excel formats problem, Too many different cell formats, VBA

Sometimes with Excel you receive an error message, saying “Too Many Different Cell Formats”. This is …

VBA – Too many different cell formats Read more →

MySQL for MS Excel
Else - Just Tricks, SQL

MySQL for MS Excel

Vitosh Nov 11, 2015 Tagged with Excel, mySql excel, mySQL for excel

Yes, it exists! Today, I somehow managed to install it from here. This is how it …

MySQL for MS Excel Read more →

Simple Excel – Usage of column names for formulas
Else - Just Tricks

Simple Excel – Usage of column names for formulas

Vitosh Jan 22, 2015 Tagged with Excel, usage of column names for formulas

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 →

Posts pagination

Previous 1 … 6 7 8 9 10 Next

Copyright © 2026 VitoshAcademy