And I found it. I had a macro and a
range with the same name.

Ah, that old chestnut. I should have thought of that!

Regards,
Peter T

"scott w t" wrote in message
...
Thanks again, Peter. I tried what you recommended but it didn't work.
However, it inspired me to go through the Excel macro and comment
everything
out and then add it back in line by line and access it from Access through
automation to see where it got hung up. And I found it. I had a macro and
a
range with the same name.

Happy new year, Scott

<snip