fette_hehne
New Member
- Joined
- Oct 18, 2005
- Messages
- 24
HI,
I created a command button which delets the any content in a certain range
Private Sub CommandButton1_Click()
Worksheets("Paste").Range("A6:N6200").ClearContents
End Sub
When I now copy a certain range from another spreadsheet and want to paste this selection into the first worksheet where I deleted the previous content neither CTRL + V nor Edit/Paste is working. What is the reason for that????
I checked under Tools/Options whether 'Show past option buttion' has been selcted and it is still ticked.
I created a command button which delets the any content in a certain range
Private Sub CommandButton1_Click()
Worksheets("Paste").Range("A6:N6200").ClearContents
End Sub
When I now copy a certain range from another spreadsheet and want to paste this selection into the first worksheet where I deleted the previous content neither CTRL + V nor Edit/Paste is working. What is the reason for that????
I checked under Tools/Options whether 'Show past option buttion' has been selcted and it is still ticked.