本帖最后由 龙送农 于 2015-1-26 18:43 编辑
VBA查找删除问题:因“过次页”“承前页”所在的行设置不规范。想查找F列“过次页”“承前页”所在的行并删除。
[已解决]VBA自动插入行问题
http://www.excelpx.com/thread-338091-1-1.html
之前的帖子,我不是写了删除的代码吗,你打开附件就找得到 - Sub tt()
- Dim rng As Range, lrow&, i&
- lrow = Cells(Rows.Count, 1).End(3).Row
- For i = 1 To lrow
- If Cells(i, "F") = "过次页" Or Cells(i, "F") = "承前页" Then
- If rng Is Nothing Then Set rng = Cells(i, "F") Else Set rng = Union(rng, Cells(i, "F")) 'F列的两个单元格
- End If
- Next
- If Not rng Is Nothing Then rng.EntireRow.Delete
- End Sub
复制代码
|