|
每次运行到这一句就报错,提示信息:“运行时错误1004,应用程序定义或对象定义错误...Cells(c, 62).Value = ling
Private Sub CommandButton1_Click()
Dim ling As Integer, yi As Integer, er As Integer, san As Integer, si As Integer, wu As Integer, liu As Integer, qi As Integer, ba As Integer, jiu As Integer
Dim i As Integer, Hanghao As Integer, Bai As Integer, Shi As Integer, Ge As Integer, no1 As Integer
Dim weihao As Integer
Worksheets("一").Activate
Hanghao = TextBox1.Value
Bai = Sheets("一").Range("c1").Value
Shi = Sheets("一").Range("d1").Value
Ge = Sheets("一").Range("e1").Value
For i = 3 To 209
Cells(Hanghao + 1, i).Value = Cells(3, i).Value
weihao = Worksheets("一").Cells(Hanghao, i).Value
If weihao = Bai Then
Cells(Hanghao, i).Interior.ColorIndex = 38
no1 = Cells(Hanghao + 1, i).Value
NO (no1)
ElseIf weihao = Shi Then
Cells(Hanghao, i).Interior.ColorIndex = 38
no1 = Cells(Hanghao + 1, i).Value
NO (no1)
ElseIf weihao = Ge Then
Cells(Hanghao, i).Interior.ColorIndex = 38
no1 = Cells(Hanghao + 1, i).Value
NO (no1)
Else
End If
Next i
UserForm1.Hide
Cells(c, 62).Value = ling
Cells(d, 62).Value = yi
End Sub
Private Sub CommandButton2_Click()
UserForm1.Hide
End Sub
Public Function NO(no1 As Integer) As Integer
Select Case no1
Case 0
ling = ling + 1
Case 1
yi = yi + 1
Case 2
er = er + 1
Case 3
san = san + 1
Case 4
si = si + 1
Case 5
wu = wu + 1
Case 6
liu = liu + 1
Case 7
qi = qi + 1
Case 8
ba = ba + 1
Case 9
jiu = jiu + 1
End Select
End Function
|
|