Private Sub Worksheet_Calculate()
Application.EnableEvents = False
If UCase([b60000]) = "K" Then
[G59281:bk60000] = [ G60001:bk60720].Value
End If
Application.EnableEvents = True
End Sub
請教各位大大 當 [G59281:bk60000] 複製到[ G60001:bk60720].
順便自動存檔一次 = (ctrl+s)
該如何做.........謝謝您的指導作者: register313 時間: 2012-3-8 08:17