Thanks, that would work if I were going to be coding in the spreadsheet,
however, what I needed to do was use the data as a linked  file inside of
Access. I ended up copying the pertinent data to another spreadsheet  and
using that as my linked table.

It's a bummer that Clear Contents did not re-set the "used range" like it
should have.