Select sheet in Excel without knowing the name.

[Kraig K]

I can't seem to get this to work. I want to manipulate data on an Excel sheet and I don't know the name of the sheet. If I rename the sheet to "Sheet1" it works fine but otherwise no.

This reports the name correctly:

Print objExcel.ActiveSheet.Name

But then this code doesn't work:

i = 1
Do
   GetCount = .Cells(i, 2)
   i = i + 1
Loop Until GetCount = ""

It says method "Cells" failed. As you can see, I'm trying to find out how many data points are in a column, if someone has an easier way...

The test data I have currently only has one sheet, what if I had more than one?