ExcelBanter - Can Paste-Special-Values be VBA programmed?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can Paste-Special-Values be VBA programmed? (https://www.excelbanter.com/excel-programming/318354-can-paste-special-values-vba-programmed.html)

Simon Hughes

Can Paste-Special-Values be VBA programmed?

Paste-Special-Values is a sequence that I seem to use quite a lot and I'd
like to make it a shortcut choice when right-clicking on a cell. So far
though, I can't seem to find any way to do it. (I know how to put something
into a shortcut menu, just not how to recreate the Paste-Special-Value
part.) Any suggestions?

Tom Ogilvy

Can Paste-Special-Values be VBA programmed?

ActiveCell.PasteSpecial xlPasteValues

--
Regards,
Tom Ogilvy

"Simon Hughes" wrote in message
news:CoHsd.196523$HA.14109@attbi_s01...
Paste-Special-Values is a sequence that I seem to use quite a lot and I'd
like to make it a shortcut choice when right-clicking on a cell. So far
though, I can't seem to find any way to do it. (I know how to put
something
into a shortcut menu, just not how to recreate the Paste-Special-Value
part.) Any suggestions?

benitAAvi

Can Paste-Special-Values be VBA programmed?

You may simulate the paste special option with the sendkey commands in VBA

Avi

"Simon Hughes" wrote in message
news:CoHsd.196523$HA.14109@attbi_s01...
Paste-Special-Values is a sequence that I seem to use quite a lot and I'd
like to make it a shortcut choice when right-clicking on a cell. So far
though, I can't seem to find any way to do it. (I know how to put
something
into a shortcut menu, just not how to recreate the Paste-Special-Value
part.) Any suggestions?

All times are GMT +1. The time now is 12:37 PM.