gerotutu
04-17-2017, 01:54 PM
Hi! I need your help to check this macro I found in internet to copy and paste without formatting always by default in Excel. I tried it but it made a complete mess. I get always the same problem: whatever is in the clipboard gets stuck there and everytime I click a cell (any) the content is pasted again and again
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next
Target.PasteSpecial xlPasteFormulas
Application.CutCopyMode = True
End Sub
Is it posible to make Ctrl-V only available as formula without any other formatting? I want to keep the excel clean and tidy.
Hope you can help me. Many thanks!
Gerónimo
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next
Target.PasteSpecial xlPasteFormulas
Application.CutCopyMode = True
End Sub
Is it posible to make Ctrl-V only available as formula without any other formatting? I want to keep the excel clean and tidy.
Hope you can help me. Many thanks!
Gerónimo