1
活动单元格:ActiveCell.FormulaR1C1
活动单元格同行往前推一格:ActiveCell.Offset(0, -1).
复制:Selection.Copy 粘贴:ActiveSheet.Paste
Windows("单元格.xls").Activate:激活excel
Sheets("Sheet1").Select:激活excel 里的表
Select Case ActiveCell.FormulaR1C1
Case Is = "MM"
ActiveCell.Offset(0, -1).Value = "a"
Case Is = "BB"
ActiveCell.Offset(0, -1).Value = "b"
。。。。。
End Select
2
Sub mysub()
Dim HANG As Long
Dim col As Integer
Dim colwrite As Integer
col = 9
colwrite = 8
HANG = Range("I65536").End(xlUp).Row
For int1 = 1 To HANG
Select Case Cells(int1, col)
Case Is = "MM"
Cells(int1, colwrite).Value = "a"
Case Is = "BB"
Cells(int1, colwrite).Value = "b"
Case Is = "DD"
End Select
Next int1
End Sub