|
点击“生成数据”按钮,输入需要分割的值(例如100),按值在B\C列提取起始码与结束码,如果出现尾数时提示(尾数,不够数量),如果数据刚好能除尽就不提示,按钮是模拟其它的代码(有一些代码了)。
简单给你代码修改了一下,你可以在我的代码基础上自己添加修改。 - Sub 生成数据()
- Dim vData As Variant, sPath As String
- Dim nNum As Integer, nI As Integer, nJ As Integer, nRow As Double
- Dim y, ar, br, cr, n, i
- ReDim br(1 To 1)
- ReDim cr(1 To 1)
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- sPath = InputBox("请输入需要分隔数据数量:")
- nNum = Val(sPath)
- If nNum <> 0 Then
- ReDim br(1 To 1)
- ReDim cr(1 To 1)
- Range("b2:b65536").ClearContents
- Range("c2:c65536").ClearContents
- y = Range("a65536").End(3).Row
- ar = Range("a2:a" & y)
- For i = 1 To UBound(ar) Step nNum
- n = n + 1
- ReDim Preserve br(1 To n)
- ReDim Preserve cr(1 To n)
- br(n) = ar(i, 1)
- If (i + nNum - 1) <= y Then
- cr(n) = ar(i + nNum - 1, 1)
- Else
- cr(n) = ar(y - 1, 1) & "不够"
- End If
- Next i
- Range("b2").Resize(UBound(br), 1) = Application.Transpose(br)
- Range("c2").Resize(UBound(cr), 1) = Application.Transpose(cr)
- Else
- If MsgBox("输入有误或未输入,是否取消输入?", vbYesNo) = vbYes Then GoTo 退出生成数据
- End If
- 退出生成数据:
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|