A collection of posts relating to Microsoft Excel
A VBA For loop allows you to repeat a block of code a set number of times. In its most basic form, shown below, a variable i keeps track of how many times the loop has ran (Note: it is quite common across programming languages to use the variables i, Read more…
In VBA, there are multiple methods you could use to clear the values of a cell on a spreadsheet. Here we quickly discuss two methods and highlight the difference between the two methods. Method 1 – Range.Clear Clear is used when you wish to clear the formulas and/or values from Read more…
The following is a full list of built-in functions available in Microsoft Excel. This list includes functions available only with Microsoft 365 and Office 2019. The list is derived from the list provided by Microsoft. A B C D E F G H I J K L M N O Read more…
By default, the Developer tab in Microsoft Excel will not be visible when you open a new Excel workbook. If you plan on recording macros or writing custom VBA code, you will want to enable the tab so you can have access to the functionality the tab provides. Making the Read more…
Disabling the “Compile Error” popup in Excel VBA is simple. Click Tools then select Options. Uncheck the “Auto Syntax Check” box and you are done!