Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteSpecial:VBA vs right click
"Ed" wrote in message
... When you bring up Paste Special witha right click, you can choose to paste only formats, or formulas, or values, etc., but not more than one. With VBA, can I PasteSpecial format AND values, but NOT formulas? Hi Ed, VBA is the same as the UI in this regard. You can perform as many PasteSpecial operations in a row as you like, though, in order to get the combination you're after. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
key shortcut for PasteSpecial-Values | Excel Discussion (Misc queries) | |||
PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
Copy PasteSpecial not working | Excel Worksheet Functions | |||
PasteSpecial failed | Excel Programming | |||
pastespecial | Excel Programming |