Worksheet vs. Worksheets
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...
--
Adios,
Clay Harryman
|