From my web searches I have found there is a lot of talk about this problem,
but I have never found a real solution (i.e. do SOMETHING to make the
usedrange actually work). The solution that seemed to work in previous
releases was to run something like activesheet.usedrange but that does not
work in excel 2000. Some have suggested that closing and saving a file
resets the used range, but I have not seen that to be true either.

Does anyone have a REAL solution. I am not interested in functions that find
a range that has data in it - I can write that easily. The only solution
I'm interested in is once that allows me to use usedrange "properly".

Thanks!