Have a look at Ron de Bruin's Copy/Paste/Merge VBA code examples.
http://www.rondebruin.nl/tips.htm
Gord Dibben MS Excel MVP
On Fri, 6 Jul 2007 23:16:04 -0700, sand wrote:
is there any way to copy some cells from excel files of specific folder and
paste it in a single excel file