On Jul 15, 4:13*pm, Dave Peterson wrote:
My real question is about the Range("Date") cell. *Is it in the worksheet named
"Work Sheet"?

But since it worked ok, I guess I guessed right.



wrote:

<<snipped
Dave,

* * Thank you very much for your quick response. *To answer your
question work sheet is in workbook. *I tried out your code and it
worked everytime I used it.

-Chris

--

Dave Peterson

Dave,
Yes you did guess correctly. The range "Date" is in the active
workbook "WORKBOOK.XLS" on Sheet "Work Sheet".

Thanks,
Chris