Hi
If you like send me a sample of one of your workbooks with a detailed
description what you want to achieve and maybe there is an easier
solution.

I'm still not sure, what kind of #weekly' report you want to create.
Why do you want to access all worksheets within one workbook if each
workbook represents only 1 day of your month

Frank


for some reason that add-in isn't working right, maybe i'm doing
something wrong, I"ll give it a second looking over in a minute.

In the meantime, is there anytype of VBA alternative to this?

I mean, all it is that I'm trying to do is create weekly report. The
workbook, is named after the month(Febuary) and each worksheet with
the exception of the first and the last (named Top and Bottom) are
days of the month (named 01, 02,... ...30, 31). Each worksheet has
dates on them, always in the same column. I just want to know how
many of the dates are between 2/2/04 and 2/5/04 on all of workbsheets
between Top and Bottom.

Surely there must be a way to do this. Or some type of alternative
approach to getting my results. any help?

It doesn't seem that complex, and yet it is...