Video 18

Having dynamically defined a range of cells to work with in part 17, we will continue our application of Excel VBA in part 18 by looping through the range of cells. We’ll explore how to tackle our next coding challenge: how to establish if a worksheet with a particular name already exists in the file. It will involve some kind of ‘loop within a loop’ type setup – cool!