excel - 检查范围内的每个单元格是否有特定字符串？

Question

我想要一个 VBA 代码，通过它我可以检查具有特定文本的范围内的每个单元格？

EG: for each cell in range (a:a)
    if value of cell = "specific text"
    do this
    else 
    do that

*

如何在 VBA Excel 中执行此操作？

Answer 1

就在这里，但请先尝试在 Google 上查找

Sub eachCell()
    Dim c As Range
    For Each c In Range("A1:D21")
        If (c.Value = "mytext") Then    'if value of cell = "specific text"
            c.Value = "other text" 'do this
            Else
            c.Value = "other text 2"  'do that
        End If
    Next c
End Sub