possibly

set rng = xlapp.ActiveSheet.Range("A1").currentRegion

--
Regards,
Tom Ogilvy

"Al" wrote in message
...
How can I determine the start and the end of populated
cells in excel from a form in access. I am using access
97.
thank you
Al