ä¸è¬éç¨ååºçæ¹å¼ï¼ä¾å¦ï¼å°Dåä¸ä¸ºâå¦âçæ´è¡å é¤ï¼ Sub test() For i = Cells(Rows.Count, 4).End(xltoup).Row To 1 If Range("D" & i) = "å¦" Then Range("D" & i).EntireRow.Delete End If Next End Sub
sub test() set a=thisworkbook.sheets("sheet1") dim mycell as range for each mycell in a.UsedRange if mycell>10 then mycell.clear end if next end sub本回答被网友采纳