| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste special values but not... | Excel Worksheet Functions | |||
| Paste Special values only | Excel Worksheet Functions | |||
| paste special values | Excel Worksheet Functions | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
| Paste special values | Excel Programming | |||
Linear Mode
