See Ron de Bruin's site for code.
http://www.rondebruin.nl/copy2.htm
Gord Dibben MS Excel MVP
On Wed, 27 Jan 2010 09:41:03 -0800, iamoktc
wrote:
I have 17 seperate worksheets in one book. I now want to combine all that
information, which is in identical format, onto one worksheet.