Thank you all for your responses. Tom's solution works for my application
but I am filing them all away for future reference. Thanks again for your
input

-Jonathan

"Jonathan" wrote in message
...
Hello,

I am writing a VBA procedure in MS-Access 2002 to read rows from an Excel
worksheet and copy them to an Access table. Is there a way to know the
total
number of populated rows without reading through all of them and looking
for
an end of range marker such as an empty cell? That's what I'm doing
currently. Unfortunately some populated rows have empty cells.



Thanks in advance

--
Jonathan
KingsKinght1 <at hotmail <dot com