Examples and tutorials that show you how ASAP Utilities will save you time and makes YOU rock in Excel. Im going to add this section to the Microsoft Excel Help section menu on the left of the website. An excel user contacted me and questioned how to create a. Repeating a task with a Do loop. When you create an Excel VBA subroutine, you expect it to take data from acell or an array, transform it in some way, and change the workbook or display the result. Sometimes, however, you will want your VBA code to run until a condition is met. When you want a segment of your code to repeat until it encounters a specificcondition, you can use the Do Loop construction. The Do Loop construction is particularly useful for finding the first empty cell in a column. As an example, suppose you have a Suggestion Box form where store visitors canenter their e mail address, name, and suggestions. You want the VBA code to take their input and write it in the first empty rowin another worksheet for example, lets say that I was writing the input from the form to here, on Sheet. Now, before I show you the example code, I want to tell you how to stop yourcode from running, in case you create a loop that wont stop on its own. Its easier than you think to write a loop that will run on to infinity. Working with Tables in Excel 2013, 2010 and 2007 VBA This article has also been published on Microsoft Office Online Working with Excel tables in Visual Basic for. Excel Formulas, Data, Tables, VBA Ways to use Excel formulas and data, including worksheet functions, range names, cell references, databases, lookup methods.