Hi
You could do something like
For i = 1 to workbooks.count
workbooks(i).activate
'do whatever you want to the active workbook here
next i
HTH
Ken
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 28/05/2004