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

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

Doug:

Try these and see if they help:
http://www.mvps.org/dmcritchie/excel...m#makelastcell

http://www.contextures.com/xlfaqApp.html#Unused



Ed



"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