loop my range with criteria

sal21 · Jul 11th 2012

In column F (started from cell 2 to 65536)i can have:

AAA
AAA
BBB
CCC
AAA
...
AAA

is possible to set MyRange only the row with AAA and loop it?

Tks.

Richie(UK) · Jul 11th 2012

Re: loop my range with criteria

Hi,

Is this what you had in mind?

Code

Sub Test()
    Dim MyRange As Range, MyCell As Range


    With Worksheets("Sheet1")
        .Range("F2").AutoFilter Field:=1, Criteria1:="AAA"
        Set MyRange = .AutoFilter.Range.SpecialCells(xlCellTypeVisible)
        For Each MyCell In MyRange
            MsgBox MyCell.Address
        Next MyCell
    End With
    
End Sub

Display More

loop my range with criteria

Participate now!

Share