Introduction In the MS Excel’s Visual Basic Editor, Sub is a statement, like a function fun(), that performs a specific task. A sub is a piece of code that performs a specific task and does not return a result. The purpose of a subroutine is to
Out of all the challenges you might face in MS Excel VBA, there is one that may very well be the universal “Achilles Heel.” The user… To illustrate this, consider the following scenario: You just spent several days building and successfully testing a great MS
Introduction Every programming language has its own grammar and vocabulary — technically known as syntax. Having a mastery of any language implies that you have a sound knowledge of its syntax. As a beginner in VBA, you might be confronted with frustrating errors like the
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
Introduction In a previous article titled “VBA print to console,” you saw the use of the immediate window in VBA. You learned from that article that the VBA immediate window is a kind of playground where the VBA programmer can test code to see whether
Introduction One of the most common things to do in coding is to build logic that checks for the occurrence of multiple conditions. As a coder, whether novice or experienced, hopefully you agree that this is one of the most common coding tasks. In VBA,
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
Description FormatNumber is a property of the Range object of Excel. The Range object can be considered as a cell or a group of cells — be that a single cell, a column in an Excel table, or the UsedRange of an Excel sheet. The
Introduction When beginning your coding career, you will certainly ask yourself questions like, “What exactly is a programming language?”, “Which programming language should I learn”, “What is the difference between language A and language B”, etc. The answer to these questions and many others can
Description This error in matching occurs when the Match function is used, but a match was not found. The Match function is used in order to determine the position in a 1-dimension list at which a text or number is matched. This error is of