小弟VBA新手,学着用VBA处理实验数据,现在要在某特定行的下面插入2行,当遇到2014-12-9 9:59:00,2014-12-9 10:59:00
,2014-12-9 11:59:00等每个整点最后一分钟所在行的后面插入2行,这种VBA代码怎么编写呢,下面是我试着编写的代码,但完全不行。。。。。。
希望各位大神赐教,谢谢啦~
Sub 插入行()
Dim rng As Range
Dim a As Variant
For Each rng In Range("A2:A789")
Set a = rng.Value
If "a" Like "[*59*]" Then
rng.EntireRow.Insert
End If
Next rng
End Sub