Excel Macro Class 3 - Looping through Ranges & Working with Cells

Add to Favorites
Author: | Edits: don

Excel Macro Class 3 - How to loop through ranges of data and work with the cells in those ranges.

This includes:

  • how to loop through a row of data
  • how to loop through a column of data
  • how to loop through all rows and columns of a range of data
  • how to get values from the cells within the ranges
  • how to access any data point about the cells in the ranges
  • how to use IF statements to make logical checks within the loop

This tutorial covers the For Next Each loop.

Question? Ask it in our Excel Forum

Downloadable Files: Excel File