|
之前区域是参照I列的,对应的代码是n = Sheet1.Cells(Sheet1.Rows.Count, 9).End(xlUp).Row
如果需要参照K列,那就改成n = Sheet1.Cells(Sheet1.Rows.Count, 11).End(xlUp).Row吧,如果有其他需求,再提吧!- Sub ss()
- Dim n&, rng As Range
- n = Sheet1.Cells(Sheet1.Rows.Count, 11).End(xlUp).Row
- For Each rng In Sheet1.Range("K2:K" & n)
- If rng.Value = [E2] Then
- rng.Resize(1, 3).Offset(0, -2).ClearContents
- End If
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|