How is excel relevant to you? I’m a strong believer that Excel can pretty much do whatever you need it to do. I’m not talking about games, though I do have snake and racetrack. I’m talking about everyday scenarios. You …
Category «VBA»
VBA – Search using a loop or .Find
Find a value with a loop Grab a copy of this example workbook Say you have a list of organizations and their member counts – For this example we will work with a list of 30, but the same concepts …
Differences between loops in VBA
Looping in excel VBA When you think of loops in VBA, there are two types of loops that come to mind – Do loops and For loops. Loops in VBA for excel can loop through objects and collections, but here …