mdmackillop
08-15-2005, 04:41 PM
I'm posting in relation to this question.
http://www.vbaexpress.com/forum/showthread.php?t=4594
The attached sheet contains the following code, which seems to clear the clipboard if you try to cut/copy and paste. The actual Application method doesn't seem to matter. Any explanations?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$12" Then
Application.Calculate
Else
Application.Calculate
End If
End Sub
http://www.vbaexpress.com/forum/showthread.php?t=4594
The attached sheet contains the following code, which seems to clear the clipboard if you try to cut/copy and paste. The actual Application method doesn't seem to matter. Any explanations?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$12" Then
Application.Calculate
Else
Application.Calculate
End If
End Sub