Clayman wrote:
What's the difference? When do I use Worksheet? When do I use Worksheets?

The reason I'm asking is that I'm trying to find the value in cell A1 of the
first sheet of a workbook. This sheet may appear by different names. I've
successfully called this sheet before using
ActiveWorkbook.Worksheets("Sheet1").Range("A1").va lue. This time, I'm getting
a "Subscript out of Range" error.

Yeah - I wanna be a Geico Caveman...

Worksheet is a single worksheet-object.
Worksheets is a collection of Worksheet-objects.

HTH, CoRrRan