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.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.