2,464
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Private Sub Main()
Dim vText As String
Dim vCurr As Long
Dim vSave As Long
Dim pi&, pn As Long
vSave = -1&
pi = 2 ' 数据“从第2行开始”
Do
vText = Sheet1.Cells(pi, 1).Text
If (vText = "") Then Exit Do
vCurr = Val(vText)
If (vSave Xor vCurr) Then
pn = pi
pi = 1& + pi
Sheet1.Rows(pn).Insert Shift:=xlDown
Sheet1.Range("A" & pi & ":H" & pi).Copy Sheet1.Range("A" & pn)
Sheet1.Cells(pn, 3).Value = 0.5 * Sheet1.Cells(pi, 3).Value
End If
vSave = Val(Sheet1.Cells(pi + 1&, 1).Text)
If (vSave Xor vCurr) Then
pn = 1& + pi
Sheet1.Rows(pn).Insert Shift:=xlDown
Sheet1.Range("A" & pi & ":H" & pi).Copy Sheet1.Range("A" & pn)
Sheet1.Cells(pn, 3).Value = 1.5 * Sheet1.Cells(pi, 3).Value
pi = 1& + pn
Else
pi = 1& + pi
End If
vSave = vCurr
Loop
End Sub