I’m going to start by reviewing a couple fundamentals about selecting ranges in Excel with VBA, then I’ll discuss methods for selecting ranges with variable row numbers. Selecting Cells in Excel One of the most common situations in Microsoft Excel is that you need to
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
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
To fully understand why you’re seeing this error, you have to first understand what a function is and how it works. Basics of a function A function is a block of code which can do any repetitive task. It can be run any number of
A VBA project is nothing but the bundle of macro(s) along with the host application in which it has been coded. For example, if we write a small reusable function to split a column of cells values into two using the MS Excel VBA Editor,
The sorting feature of Excel is very useful to organize and put data into a structured format. But many times, we think of a better way to do it — only after we complete the data sorting! So somehow we have to revert the sorting
In this article, we will look at how to automate the launching of a particular action when a cell on the worksheet contains a particular value. There’re three ways that we can do this with; InStr, Like, and Find. Example 1: INSTR Instr is a
We all are very well aware of the efficiency of MS Excel. However, to further enhance its efficiency, VBA macros come in handy. Without using macros, you can easily filter out information in a dataset, based on criteria, using the ‘Filter’ feature within the ‘Data’
Introduction Freezing panes is a very handy feature that is indispensable in any Excel workbook that has more than few columns or few rows. In this article, we will take a look at exactly how to utilize the Freeze Pane feature in both Excel and
Microsoft Excel does not have the built-in worksheet functions to calculate the cross product of two vectors. Therefore, some techniques are required to do the calculation — either by setting up your own formula in a worksheet or by creating a custom VBA function. The