Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to test for valid 'Paste:=xlValues' before attempt.
I have code that pastes values at the current selection.
This works fine when the 'copy' is within excel. However, occasionally the source may be from another application in which case the 'Paste:=xlValues' fails. Is there a way to test to see if 'Paste:=xlValues' is a valid option before using it in the following code? Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Thank you. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct - Second Attempt | Excel Worksheet Functions | |||
Complie Error with xlValues | Excel Programming | |||
How to test if a workbook variable is valid | Excel Programming | |||
my first attempt at R1C1 in vba | Excel Programming | |||
How to test if a repertory is valid | Excel Programming |