You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"the-big-john" wrote in message
...
T. Valko's post was most helpful. I ended up using something along the
lines
of:
=COUNTA(INDIRECT(A2&"!A2:A50000"))
I knew about the Indirect function. I didn't know about the ampersand and
quotations.
Thanks to all.