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?