Pasting into another workbook

[mattmc419]

Hey Guys,

I'm trying to write a macro that copies values from one sheet and pastes them into Sheet1 in a different workbook.

I have the code below, but it errors out at the pasting step ( Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone )

The error is:

"Run-time error '1004';

PasteSpecial method of Range Class failed"

Anyone have any idea what's going on?

Thanks!

Please Login or Register  to view this content.

[Vikas_Gautam]

The Problem is that you used clearcontents method before pastespecial method..
The possible correction would be....

Please Login or Register  to view this content.

[mattmc419]

hmm now I'm getting,

"Run-time error '9':

Subscript out of range"

With debugging telling me that error is at,

Please Login or Register  to view this content.

[Vikas_Gautam]

Try this then..
Or Upload both files to work upon...

Please Login or Register  to view this content.