• Home
 · 
• Miscellaneous
 · 
• This program iterates through a range on an Excel Worksheet to find each occurrence of a given word

This program iterates through a range on an Excel Worksheet to find each occurrence of a given word

This program iterates through a range on an Excel Worksheet to find each occurrence of a given word, in this instance ORIG, then adds to a

API Declarations


Dim c As Object




Rate This program iterates through a range on an Excel Worksheet to find each occurrence of a given word

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

     Range("g9:g500").Select    'This range is variable upon your needs
    ORIG = 0                    'Set counter to 0
    For Each c In Range("Count")'Find range and instance
    If c.Value = "ORIG" Then
        ORIG = ORIG + 1
    End If
    Next c
    MsgBox "There are " & ORIG & " cell values for Originals in this range."
End Sub