Loop through each row of a range in Excel

excel vba loops excel-2003
Margaret picture Margaret · Sep 23, 2009 · Viewed 419.9k times · Source

This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to remember it.

How do I loop through each row of a multi-column range using Excel VBA? All the tutorials I've been searching up seem only to mention working through a one-dimensional range...

Answer

Mike picture Mike · Sep 23, 2009 
Dim a As Range, b As Range

Set a = Selection

For Each b In a.Rows
    MsgBox b.Address
Next

Related questions

How to execute a function for each cell in a column and loop through all workbooks?

Here's what I have so far: Sub TrimColumnD() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Dim c As Range For Each c In ActiveSheet.UsedRange.Columns("D").Cells c.Value = WorksheetFunction.Trim(c.Value) Next c Next …

Read More
Excel VBA - Skip sub or end sub IF Statement

My code loops through cell values in a table and sees if document with same name exists. If it does exist, it will perform an action to open those files and import data. If bProcess Then FileCounter = 0 For Each folderIDX …

Read More
VBA For Each cell In Range Format as Percentage

I've looked around for this and it seems so simple, yet I can't get it to work. I have a table and one column needs to be formatted as a percentage. Below is my code but it is not formatting …

Read More