作业帮 > 综合 > 作业

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/08/13 06:30:03
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then
Cells(Target.Row,Target.Column + 1) = Cells(Target.Row,Target.Column + 1) + 1
End If
End Sub
请问If Target.Column = 1 Then A列如何写成A1:A10
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 and Target.Row
再问: 大侠您好! 这句If Target.Column = 1 and Target.Row=5 and Target.Row