Funcres.xlam and Analysis Toolpak in Excel/VBA

An introduction to funcres.xlam Funcres.xlam is an add-in available within Microsoft Excel. This is an “Analysis Toolpak” and includes 19 different features and various statistical functions to help you work with the data available in your Excel worksheets. In order to use this add-in, which

How to Use Application.Calculation in VBA

The benefits of using Excel for calculation We are well aware that in today’s world, a machine’s brain works orders of magnitude faster than a human’s brain. By this, I mean that when there is a requirement to calculate some numbers mathematically, we have quickly

What are SendKeys in VBA?

An Introduction to Automation Every user of a computer has some mundane task to do every day. For example, you may have to execute something at a particular time on your machine or check the value of some stock or commodity every minute if you

VBA Naming Conventions: Best Practices

In any programming language it is quite natural for you to use several variables and objects to develop code. Throughout this process, you might get confused referencing them for the first time or reusing them for the second time. For example, you might create a

What is a VBA Dictionary?

A dictionary is an object in VBA (similar to a collection) that stores data like an array. It can be used to store data of any type except an array. A VBA dictionary has two parts: Key Value …where key is simply a reference to the