See Debra Dalgleish's site

http://www.contextures.com/tiptech.html

see Used Range, Reset (FAQ)
under T-Z

--
Regards,
Tom Ogilvy


"Dthmtlgod" wrote in message
...
I remember seeing something on this, when you hit CTRL END, you will see
the
true last cell used. Where is the function/utility to remove the
erroneous
rows.

Thanks,
Doug