Hi all,

Hopefully this question won't be as dolt-ish as the last one....

OK, I am writing a series of macros to run a rather large series of reports. For one of these reports, I must take data from a set worksheet called "Sort" and paste data into a worksheet that has a different name every day. The name, however, is uniform in format, and reads "9.12 Day 13" for September 12, 13 days late, and "9.13 Day 14" for September 13, 14 days late, etc.

The problem really is that the Days late is not predictable months in advance. So, what I'm wondering is whether or not there is a way to chech whether worksheets exist in a workbook, something like

If 9.12 Day 14 exists, return True, if true, paste in that worksheet (but, of course, in VB)

I'm using Excel 97, so any help on this would be greatly appreciated.

Thanks,
Joshua Wise