请教各位老师:
怎样使用VBA代码将A列所有的数据下面插入相应的行数,
以A列数据除以100后得到的整数作为该数据下插入行数的依据。
我录制了一段宏,并加入了For...Next,但不知道怎样把5改成变量
Sub 插入行()
For i = 1 To 5
Selection.EntireRow.Insert
Next
End Sub
Sub 插入行()
Dim x, k
For x = Range("a65536").End(xlUp).Row - 1 To 1 Step -1
k = x + Cells(x, 1) \ 100
If k > x Then
Rows(x + 1 & ":" & k).Insert
End If
Next x
End Sub
Sub 插入行()
Dim x, k
For x = Range("a65536").End(xlUp).Row - 1 To 1 Step -1
k = x + Cells(x, 1) \ 100
If k > x Then
Rows(x + 1 & ":" & k).Insert
End If
Next x
End Sub
Sub 插入行()
Dim x, k,cc 'cc是列数
For x = cells(65536,cc).End(xlUp).Row - 1 To 1 Step -1
k = x + Cells(x, cc) \ 100
If k > x Then
Rows(x + 1 & ":" & k).Insert
End If
Next x
End Sub
Sub 插入行1()
Dim x, k, cc 'cc是列数
For cc = 1 To 255
For x = Cells(65536, cc).End(xlUp).Row - 1 To 1 Step -1
k = x + Cells(x, cc) \ 100
If k > x Then
Rows(x + 1 & ":" & k).Insert
End If
Next x
Next cc
End Sub