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;