| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Error: Paste Special method of range class failed
I have written the following in VB to copy and paste data
from one workbook to another: ActiveSheet.Range("A6:A35").Select Selection.Copy Windows("Data_2004.xls").Activate Sheets("My Data").Select Range("A6").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False For some reason everytime I run the Macro I get the following error: 'Paste Special method of Range class failed' Can anyone help with this problem?? Cheers Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
| Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
| Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
| Paste method of worksheet class failed error | Excel Programming | |||
| error 1004 Select method of Range class failed | Excel Programming | |||
Threaded Mode
