一般模組:
Public Arr, ck%
Sub Auto_Open()
Arr = Range("h24:h29")
End Sub
工作表:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$23" Then
If ck = 1 Then Range("h24:h29") = Arr: ck = 0 Else Range("h24:h29") = 0: ck = 1
[B24].Select
End If
End Sub
一般模組:
Public Arr, ck%
Sub Auto_Open()
Arr = Range("h24:h29")
End Sub
工作表:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$23" Then
If ck = 1 Then Range("h24:h29") = Arr: ck = 0 Else Range("h24:h29") = 0: ck = 1
[B24].Select
End If
End Sub