Cells and for loops.
In this tutorial, we will take a lateral approach to ranges and instead, use cells.
This quick 5 minute video will walk you through why cells are easier to work with when iterating through loops; specifically, for loops. In addition, this video shows you the value of the debugger when testing programs at runtime. In this tutorial you will learn the basics of:
Cells instead of Range
Watch the Video for step by step instructions.
Copy and paste the code below to get you started.
<code> Option Explicit Sub using_cells() Dim iterator as Integer iterator = 1 For iterator = 1 to 13 Cells(10, iterator).Value = "" Next End Sub</code>