CopyPaste Values macro

[billyheanue]

Hi all,

I am looking for a quicker way to paste values from the clipboard.

Does anyone know how to set this up so I can assign a hotkey to this procedure?

 

[Eric W]

You need to explain a bit more what you're looking for. If you want to copy/paste something, just select it, press Control-C, move to Excel and press Control-V. Those are already built in. If there's some additional requirement, let us know.

 

[My Aswer Is This]

Give us an example of what you may be attempting to do. Sometimes copy and paste is not needed.
For example:
cells(1,1).value = cells(4,2).value
This can be done in a lot of cases without using copy and paste.

 

[billyheanue]

You need to explain a bit more what you're looking for. If you want to copy/paste something, just select it, press Control-C, move to Excel and press Control-V. Those are already built in. If there's some additional requirement, let us know.

Hi Eric,

I know that ctrl + V pastes data, but unfortunately it also pastes formatting and the underlying formulas of the data.

I want something, similar to pressing ctrl + V, that solely pastes the valuesin the copied cells - not the formatting/formula underlying it.

Thanks!

 

[billyheanue]

Give us an example of what you may be attempting to do. Sometimes copy and paste is not needed.
For example:
cells(1,1).value = cells(4,2).value
This can be done in a lot of cases without using copy and paste.

I find myself having to manually right click, and go to Paste Options --> Paste Values Only.
I'm just looking for a faster solution that can, similar to ctrl V, (maybe ctrl+shift+V), paste values only for me.



thanks!

 

[MARK858]

Click the dropdown arrow in your QAT
Click More Commands
In the Choose commands from select All Commands
Scroll and click Paste Values
Click OK

If you haven't set up a QAT post back

 

[Eric W]

There is one built-in option that might work for you. It's still a bit ungainly. Press Ctrl-Alt-V which will open the paste special box, then press "V" for values, then press Enter. Still awkward, but you can paste values from the keyboard without having to use the mouse. Alternatively, I can tell you how to set up a macro so that Ctrl-Shift-V will paste values, but the drawback there is that you'll need to copy that into every spreadsheet where you want to do that. Let me know.

 

[My Aswer Is This]

Try this:
Put the below script in your personal Workbook and assign it a keyboard command.

Sub Paste_Value()
ActiveCell.PasteSpecial xlPasteValues
End Sub