Sometimes at work we need to calculate specific metrics, KPIs or just simple percentages, with this principles you can create virtually any calculation you need for work. Having these calculations as ...

This is the code you'll need to add a personal formula in Excel VBA to calculate distances in KM between two differents pairs of latitude, longitude coordinates(as in -XX,XXXXXX;-XX,XXXXXX / ...

Microsoft's office software Excel is a powerful tool to perform day-to-day activities with, like simple arithmetic, sorting, filtering, arranging and summarising data in various formats. Excel has a ...

I have recently been messing with a small piece of code in VBA-Access that can send / recieve small text-strings over a network. I finally got it to work, but forgot to think ahead :facepalm: . Right ...

Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. I want to start off this post by thanking everyone ...