Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
dannutzza pe Simpatie
 | Femeie
25 ani
Mehedinti
cauta Barbat
25 - 52 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
When you paste the data as values only, you need to click the little square at the corner of your selection and choose Values option each time after pasting the data. The following VBA code can help you change the default paste to paste values.
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
Sub PasteAlwaysAsValue()
Selection.PasteSpecial Paste:=xlPasteValues
End Sub |
3. Then save and close the code, and press Alt + F8 keys to open the Macro dialog box.
4. In the Macro dialog, choose the used macro name PasteAlwaysAsValue and then click Options button.
5. Then in the Macro Options dialog box, under the Shortcut key section, enter the letter v.
6. And then click OK to close the Macro Options dialog, and go on closing the Macro dialog.
And now, when you paste the data with Ctrl + V, the data will be pasted as values by default.
Source:
https://www.extendoffice.com/documents/ ... fault.html
|
|
| |
|
