本人刚接触VBA,现用IF语句和循环语句写了一段代码,但运行时出错,请帮忙修改一下。 Sub 导入() Dim i, m, k As Integer For i = 1 To 8 k = 252 * (i - 1) + 2 If i < 5 Then m = 2 * i + 4 Else m = 2 * i + 5 Next i End If Sheets("总课表").Select Range(Range("c" & m), Range("IT" & m)).Select Selection.Copy Sheets("课时统计").Select Range("h" & k).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True Sheets("课时统计").Select Range("b2").Select End Sub
Dim i, m, k As Integer最好写成 dim i%,M%,K% 或 dim i as interger,m as interger,K as interger 我接着看.....
|