Select sheet in Excel without knowing the name.

[Kraig K]

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

Try objExcel.ActiveSheet.Cells(i,2) instead of .cells(i,2)

OK, it works. But I've done quite a bit of Excel manipulation and never had to do it that way before, must be becasue of the ambiguous sheet names?

Now what if I have more than one sheet? I may never, but might as well ask now just in case.