当前位置: 代码迷 >> 综合 >> vba excel 相关
  详细解决方案

vba excel 相关

热度:36   发布时间:2024-01-15 23:52:44.0

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

 

 

  相关解决方案