Multitude of random errors when cycling through workbooks in a folder to copy a range

LXN,
Welcome to the forum!
Please use code tags with your code as per forum's rule.
You have few errors and I guessed some of the lines

Please Login or Register  to view this content.

You have two

Please Login or Register  to view this content.

You need to separate between the source and destination books. For ease of reading, you should assign the source book as sourcebook=workbook.open......

Thanks of the response! I have edited my post, and changed wbold/wbnew to destinationbook/sourcebook, but I'm not sure how you're telling me to assign the variables. Could you clarify?

Thanks of the response! I have edited my post, and changed wbold/wbnew to destinationbook/sourcebook, but I'm not sure how you're telling me to assign the variables. Could you clarify? (I made a reply to my own post by accident in stead of yours. How do I delete that?)

You start with this line

Please Login or Register  to view this content.

This is where the code will be copied in to

Second line

Please Login or Register  to view this content.

And then you head to

http://www.rondebruin.nl/win/addins/rdbmerge.htm

I got a 'type mismatch' here:

Please Login or Register  to view this content.

Why could that be?

There are many lines that need to be changed, so I thought if you follow Ron's code, it will give you a good start, instead of doing by piecemeal.

But that link says it's an add-in, not a code?

Okay!
When you click the link, click again the excel tips tab, then 3rd from the list(Topics)-choose copy/paste/merge examples

I just got the code running actually! VBA didn't like that I had

Please Login or Register  to view this content.

When the variable was a workbook, and not a name.

Changing it to

Please Login or Register  to view this content.

in all such places fixed the problem, along with a few other minor changes.