Loop

A collection of 9 posts

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. Code placed between Do Until and
23 October 2020

How To Use VBA Create a Pattern In Excel

Below we will look at a program in Excel VBA that creates a pattern. Situation: Place a command button on your worksheet and add the following code lines: 1. First, we declare two
23 October 2020

How To Use Knapsack Problem In Excel

Below we will look at a program in Excel VBA that solves a small instance of a knapsack problem. Definition: Given a set of items, each with a weight and a value, determine
21 October 2020

How To Use Randomly Sort Data In Excel

Below we will look at a program in Excel VBA that randomly sorts data (in this example randomly sorts names). Situation: 1. First, we declare four variables. One variable of type String we
18 October 2020

How To Sort By Number In Excel

Below we will look at a program in Excel VBA that sorts numbers. Situation: Place a command button on your worksheet and add the following code lines: First, we declare three variables of
17 October 2020

How to Find and Remove Duplicates in Excel

Below we will look at a program in Excel VBA that removes duplicates. Situation: In column A we have 10 numbers. We want to remove the duplicates from these numbers and place the
17 October 2020