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.