Last Row Utility

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" <dougvandermark@netzero.net> wrote in message
news:%23MNxvxy8EHA.2676@TK2MSFTNGP12.phx.gbl...
> 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" <dougvandermark@netzero.net> wrote in message
news:%23MNxvxy8EHA.2676@TK2MSFTNGP12.phx.gbl...
> 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
>
>
>