Used Area of an Excel Sheet There are many situations when we need to perform an action on all rows and columns with data in an Excel sheet. In order to do that, you need to know which row/column of data is the last. In
Defining a Range In Microsoft Excel, a “range” of cells is a continuous group of cells across rows and columns. Here’s some valid examples of ranges with references to the cells: Any single cell like H54, C3. A part of any row Eg: D4:G4, H10:N10.
Integer Datatype In Microsoft VBA, variant is a common datatype. It can be used to store strings or integers or even dates. Integer is a specific datatype which can be used to store numbers of a specific length. The bigger version of an integer is
Errors Happen We may come across several functions in programming languages. In VBA, we are prone to encounter errors like: Syntax errors Compile time errors Runtime errors These are errors in code which can be handled using error handling methods. For example, you can see
What is a Match Function? The match function in MS Excel is one of the useful built-in lookup functions that work like Vlookup, Hlookup, and the Index function to return the position of exact or similar matches of the lookup value found in an array
As a program runs, you might have a parameter which changes the flow conditionally. This parameter could be an input dependent on the user. Therefore, a VBA program needs to be a way to receive input from the user during runtime. This is where InputBox
An introduction to the shell A shell is an interface in the Windows that runs commands and helps you use programs. Hence it is also called the “Command Line Interface” (CLI). In Windows, we also call it the command prompt. You can also open the
To start with, make sure you have a good understanding of what a function is and how it works. You can get a great overview in my articles here: What is “You’ve Entered too Many Arguments”? How Do You Fix “Compile Error: Argument not optional”?
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
Before we dive into the solution for the error above, let us go back to basics to make sure you understand what a function is. This will be important for fixing and troubleshooting the error. Feel free to skip ahead if you have a good