想写一个模块批量处理数据用,但是写完以后第一行就过不去.
提示子过程或函数未定义,错误指在第一行
下面是我写的程序
Sub main()
Dim RowNumber As Long
Dim PreStkcd As Long
Dim CurrStkcd As Long
Dim Trdmnt As Date
RowNumber = 2
PreStkcd = Range("A" & RowNumber)
CurrStkcd = Range("A" & RowNumber)
Do While CurrStkcd <= 601998
Trdmnt = #11/1/1991#
If PreStkcd = CurrStkcd Then
Do Until Trdmnt = #5/1/2007#
If Range("B" & RowNumber) <> Trdmnt Then
Row("RowNumber:Rownumber").Select
Selection.Insert Shift:=xlDown
Range("A" & RowNumber).Select
ActiveCell.FormulaR1C1 = CurrStkcd
Range("B" & RowNumber).Select
ActiveCell.FormulaR1C1 = Trdmnt
End If
RowNumber = RowNumber + 1
Trdmnt = DateAdd("m", 1, Trdmnt)
Loop
ElseIf PreStkcd <> CurrStkcd Then
PreStkcd = CurrStkcd
End If
CurrStkcd = Range("A" & RowNumber)
Loop
End Sub
那那段比较长的循环去掉这段运行就没有问题,但是加进去以后提示的是第一行出错,迷茫了...在线求解>_<