I would go to the Excel VBA newsgroup, post the code, and ask how it shold
be altered for open workbooks.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"carl" wrote in message
...
Thank you for your help. This code looks like it is designed for workbooks
that are not open ?

"Anne Troy" wrote:

Try this:
http://vbaexpress.com/kb/getarticle.php?kb_id=773

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"carl" wrote in message
...
I have 10 open workbooks that each contain 30 worksheets.

Is there a way to have these 300 worksheets consolidated into one
workbook
?

Thank you in advance.

Regards.