|
各位网友好,有下面一段程序,想填充第4列,但运行后不能填充,
Sub ìî3ä()
m = Sheets("本科").Range("a100000").End(xlUp).Row
For i = 2 To m
If Left(Sheets("本科").Cells(i, 3), 1) = "1" Then
Sheets("本科").Cells(i, 4) = "本科提前批"
ElseIf Left(Sheets("本科").Cells(i, 3), 1) = "2" Then
Sheets("本科").Cells(i, 4) = "本科一批"
End If
Next i
MsgBox "填充完毕"
End Sub
给看看问题在哪里,如何改正
谢谢
- Sub 填充()
- m = Sheets("本科").Range("a100000").End(xlUp).Row
- For i = 2 To m
- If Left(Sheets("本科").Cells(i, 5), 2) = 1 Then
- Sheets("本科").Cells(i, 6) = "本科提前批"
- ElseIf Left(Sheets("本科").Cells(i, 5), 2) = 2 Then
- Sheets("本科").Cells(i, 6) = "本科一批"
- End If
- Next i
- MsgBox "批次填充完毕!"
- End Sub
复制代码
|
|