Thanks Gord, I'll have a look.

Jim
"Gord Dibben" wrote in message
...
Check out Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the codes you find under his Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP

On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery"

wrote:

Does anyone know what code I could use to copy sheets from several files
in
the same folder into a master control file?