第2个回答 2010-06-09
Sub atest()
i = Application.InputBox("输入要判断数据所在行的字母:如果在T行就输入字母T")
Range("b1").Select
totalR = ActiveCell.End(xlDown).Row
For R = ActiveCell.Row To totalR
If ActiveCell < 1000 Then
Selection.Offset(0, 1).Value = "A"
ActiveCell.Offset(1, 0).Select
Else
Selection.Offset(0, 1).Value = "B"
ActiveCell.Offset(1, 0).Select
End If
Next R
End Sub