在Excel VBA中将循环从每个单元格更改为特定范围

Dim cell As Range
Dim rng As Range

Set rng = Range("A1:C10") ' 设置特定范围

For Each cell In rng ' 遍历范围内的每个单元格
    ' 在这里编写对每个单元格的操作
Next cell

For Each cell In rng
    cell.Value = cell.Value * 2 ' 将每个单元格的值乘以2
Next cell

For Each cell In rng
    If cell.Value = 0 Then
        Continue For ' 跳过值为0的单元格
    End If
    
    ' 在这里编写对非零单元格的操作
    
    If cell.Value = 10 Then
        Exit For ' 当值为10时退出循环
    End If
Next cell