There’s a way to programmatically define a range of cells to work with in Excel Video 422. I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422. I’m also adding a few new functions as well, so I hope this isn’t too much for one video. Hopefully the idea of being able to use code to dynamically define a range makes sense and will be helpful for you in your macros and VBA.
Watch for the code that tells Excel how many rows to work with in our example. That bit of code will come in handy in future projects. Also watch for how to resize a range. Once we find a blank column, we expand the range to five columns to shade all five at once.
Stay tuned. We’ll slow down a bit and talk more about looping in the next series of Excel Videos. Thanks for watching.
