Range COPY paste in workbooks sheets as variable

[Fean]

Hi
i am not an vba expert and i am struggling with a copy of a range between workbooks.

Made a macro which does a sheet count (for getting the sheetsnames equal i both workbooks etc placed hardcoded in Irow 12 for a loop.

I want to copy a certain range (A1:M40) for all the same worksheets from workbook1 into workbook2, should be very easy.. Tried it with copy and destination etc..



i am getting a debugger at the .PasteSpecial Paste:=xlPasteValues

A Run-time error "1004"
That command cannot be used on multiple selection

So far;

[BobBridges]

Originally Posted by Fean

i am getting a run time on the copy....

A run-time error, I guess you mean. And the error is...?

(Always include that, if you get one. Well, almost always.)

[Fean]

Originally Posted by BobBridges

A run-time error, I guess you mean. And the error is...?

(Always include that, if you get one. Well, almost always.)

Sorry indeed.
A Run-time error "1004"
That command cannot be used on multiple selections (*will put this in the orginal post..)

I have been trying multiple ways.. now it bugs on the "pasteSpecial"

[Fean]

Solved! forgot to use With sheet... end sheet. The paste special should be treated by this!!