How To Use VBA Complex Calculations In Excel
Oct 24, 2020
How to define complex numbers in Excel and perform mathematical operations such as addition, subtraction, multiplication and division.
#Tutorial#How To#VBA#Loop
How To Use VBA Create a Pattern In Excel
Oct 23, 2020
Below we will look at a program in Excel VBA that creates a pattern.
How To Use VBA Do Until Loop In Excel
Although not used very often on this site, you might find yourself in a situation where you want to use the Do Until Loop in Excel VBA.
How To Use Knapsack Problem In Excel
Oct 21, 2020
Below we will look at a program in Excel VBA that solves a small instance of a knapsack problem.
How To Use Excel VBA For Loop through Defined Range
Oct 19, 2020
Below we will look at a program that loops through a defined range.
How To Use Excel VBA For Loop through Entire Column
Below we will look at a program in Excel VBA that loops through the entire first column and colors all values that are lower than a certain value.
How To Use Randomly Sort Data In Excel
Oct 18, 2020
Below we will look at a program in Excel VBA that randomly sorts data (in this example randomly sorts names).
How to Find and Remove Duplicates in Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that removes duplicates.
How To Sort By Number In Excel
Below we will look at a program in Excel VBA that sorts numbers.