Last week we looked at using the After, SearchDirection and SearchOrder parameters of the Find method.

Last week we ran into the SearchOrder parameter of the Find function. We knew that we could go right across the row or down the column. But what if we wanted to manipulate the direction of which we searched? Instead of going down the columns using xlByColumns what if we wanted to go up?

Last week we set the After parameter for the Find method to distinguish which cell we wanted to start from. But it defaulted to go across the row. It can be set in order to go down the columns first using the SearchOrder parameter.

Having stumbled upon the Find method last week, we’re going to lay fingers on some of the parameters. Last time we did the basic search looking for a simple string within a Range. Let’s go back to our worksheet last week: ...

It’s easy to get lost in a sea of data, but at times we want to find something in particular, be it a word, number or formula. The Find method in VBA can help us do that!

Welcome back to the VBA Blog! Continuing on our series on the Do...Loop.

The second reason that Do…Loop is superior is that While Wend loops check for the condition prior to running – but with Do…Loop the condition can be checked at the end...

Last week this blog While Wend-ed down a loopy path, but now it is time to find better things to Do. Converting While Wend loops to Do Loop syntax.

Last week we looked at For Each…Next loops – but this time let’s have a look at While Wend loops.

Loops are a powerful tool in programming to repeat a sequence of instructions. But what if you want to perform an action to every object in a set?