我要根据B中是否有单词从两列A和B复制一些数据,PRNA
然后将A和B复制到“ Sheet1”中。我现在面临的问题是,它复制了所有具有的内容,PRNA
但有时也会复制它Not available
。这是代码:
Dim Cell2 As Range, LastRow2 As Long
Dim count As Integer
LastRow2 = Cells(Rows.count, "B").End(xlUp).Row
Set rng3 = Range("B2:B" & LastRow2)
Set ws = Sheets("Sheet1")
For Each Cell2 In rng3
If Cell2.Value = "PRNA" Then
'Range(Cells(rng3.Row, 1), Cells(rng3.Row, 2)).Copy
'Range("A1").Offset(count, 0).PasteSpecial
Range(Cells(Cell2.Row, 1), Cells(Cell2.Row, 2)).Copy Destination:=ws.Range("A1").Offset(count, 0)
count = count + 1
End If
Next Cell2
所以我只复制PRNA
单元格B旁边的单元格A,其中有个PRNA
。
这是输出:
我不知道这里的问题是什么..也许循环太快了吗?
这将起作用:
Sub copyPRNA()
Dim ows As Worksheet
Dim tws As Worksheet
Dim rng As Range
Dim cell2 As Range
Dim cnt As Long
Set ows = ActiveSheet
Set tws = Sheets("Sheet1")
Set rng = ows.Range(ows.Range("B2"), ows.Range("B" & ows.Rows.Count).End(xlUp))
For Each cell2 In rng
If cell2 = "PRNA" Then
tws.Range("A" & tws.Rows.Count).End(xlUp).Offset(1).Resize(, 2).Value = ows.Range(cell2.Offset(, -1), cell2).Value
End If
Next cell2
End Sub
在使用范围和单元格时,请始终使父级合格。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句