How To Use The Offset VBA In Excel
Oct 18, 2020
The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range (border below for illustration only).
How to Customize Excel Status Bar In Excel
Oct 17, 2020
The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro.
How To Insert And Run Code From A Module In Excel
Oct 17, 2020
As a beginner to Excel VBA, you might find it difficult to decide where to put your VBA code.
How to Reverse String in Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that can reverse strings.
How To Sort Birthdays (Dates) In Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that sorts birthdays to months first and days second (so we ignore years).
How To Split Text String At Specific Character In Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that separates strings.