Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i&, j&
Dim x
If Target.Column = 7 And Target.Row <> 1 Then
If Target.Count = 1 Then
ActiveCell.Select
x =Selection.Address ’这里无法表达出效果,我希望Selection.address的值能写入变量x
Else
MsgBox "不支持多单元格编辑"
Cells(1, 1).Activate
End If
End If